Answer the question
In order to leave comments, you need to log in
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 <span data-unit="currency" class="_1JgRsVbn _2z-UMF0a">₽</span>
</span>
</div>
<div class="_2hSu1LGR jnCa8gLp _1nqNAWsE _37ySe07R">
<span>16 <span data-unit="currency" class="_1JgRsVbn _2z-UMF0a">₽</span>
</span>
</div>
<div class="_2hSu1LGR hkY9ISU2 _1nqNAWsE">
<strong>
<span>23 <span data-unit="currency" class="_1JgRsVbn _2z-UMF0a">₽</span>
</span>
</strong>
</div>
<div class="_2hSu1LGR _1TG1lksc _1nqNAWsE">
<strong>
<span>1 691 <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
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'?)))
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question