A
A
akelsey2020-04-18 00:09:16
css
akelsey, 2020-04-18 00:09:16

How to copy div table in Excel?

Hello,

Previously, the Sber table for mortgage payments in the LC was apparently laid out with table tags, and I just took and copied the table and pasted it into Excel, doing the manipulations I needed.
Now apparently they have a new encoder / layout designer (I don’t know who), and all tables are now in div. When you insert such a table into Excel, all the data is inserted into one column. Is there some light and elegant fix?

Here is an example of a line (it doesn’t even work with a replacement, they crafted unique guides for classes):

<section class="_16GKUduA">
  <div class="_82cr1Wxe">
    <div class="_2hSu1LGR JcVwWDtr _37ySe07R _1kB5gMDe">Дата</div>
    <div class="_2hSu1LGR JcVwWDtr _37ySe07R _3W1_5QdT">Основной долг</div>
    <div class="_2hSu1LGR JcVwWDtr _37ySe07R jnCa8gLp">Проценты</div>
    <div class="_2hSu1LGR JcVwWDtr _37ySe07R hkY9ISU2">К оплате</div>
    <div class="_2hSu1LGR JcVwWDtr _37ySe07R _1TG1lksc">Остаток основного долга</div>
  </div>
  <div class="_82cr1Wxe">
    <div class="_2hSu1LGR _1kB5gMDe _1nqNAWsE _37ySe07R">19.01.2019</div>
    <div class="_2hSu1LGR _3W1_5QdT _1nqNAWsE _37ySe07R">
      <span>7 &nbsp;<span data-unit="currency" class="_1JgRsVbn _2z-UMF0a"></span>
      </span>
    </div>
    <div class="_2hSu1LGR jnCa8gLp _1nqNAWsE _37ySe07R">
      <span>16&nbsp;<span data-unit="currency" class="_1JgRsVbn _2z-UMF0a"></span>
      </span>
    </div>
    <div class="_2hSu1LGR hkY9ISU2 _1nqNAWsE">
      <strong>
        <span>23&nbsp;<span data-unit="currency" class="_1JgRsVbn _2z-UMF0a"></span>
        </span>
      </strong>
    </div>
    <div class="_2hSu1LGR _1TG1lksc _1nqNAWsE">
      <strong>
        <span>1 691&nbsp;<span data-unit="currency" class="_1JgRsVbn _2z-UMF0a"></span>
        </span>
      </strong>
    </div>
  </div>
</section>

Answer the question

In order to leave comments, you need to log in

2 answer(s)
R
raury, 2020-04-18
@raury

I would try to write a script that creates a .csv file with all the table data, and then just import it into excel. Or are you with js on 'Your Highness'?)))

N
Nick Bo, 2020-04-20
@Bonik83

Comrades, the easiest way is powerquery imports data from Sberbank, even their html, even from csv. Install this add-on and forget about complicated moves

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question