You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The information above provides data about the width and height for every cell with data (interestingly, for cells without data width and height above formatting is still preserved when closing and opening the excel sheet but I cannot find it anywhere in the xml files generated during decompression).
I was wondering if the above data is already easily accessible in the package?
To be more precise, I would like to find out the exact position of the text content within a cell but I guess this data is not readily available and would need the width and height of a cell, as well as font size and alignment to do that;
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hi, Team!
I see the following xml information for an excel sheet:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac xr xr2 xr3" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac" xmlns:xr="http://schemas.microsoft.com/office/spreadsheetml/2014/revision" xmlns:xr2="http://schemas.microsoft.com/office/spreadsheetml/2015/revision2" xmlns:xr3="http://schemas.microsoft.com/office/spreadsheetml/2016/revision3" xr:uid="{00000000-0001-0000-0000-000000000000}"><dimension ref="A1:A7"/><sheetViews><sheetView tabSelected="1" zoomScale="125" workbookViewId="0"><selection activeCell="A8" sqref="A8"/></sheetView></sheetViews><sheetFormatPr baseColWidth="10" defaultColWidth="8.83203125" defaultRowHeight="13" x14ac:dyDescent="0.15"/><cols><col min="1" max="1" width="43.83203125" customWidth="1"/></cols><sheetData><row r="1" spans="1:1" ht="152" customHeight="1" x14ac:dyDescent="0.2"><c r="A1" s="1" t="s"><v>0</v></c></row><row r="3" spans="1:1" x14ac:dyDescent="0.15"><c r="A3" t="s"><v>1</v></c></row><row r="4" spans="1:1" x14ac:dyDescent="0.15"><c r="A4" t="s"><v>2</v></c></row><row r="5" spans="1:1" x14ac:dyDescent="0.15"><c r="A5" t="s"><v>3</v></c></row><row r="6" spans="1:1" ht="64" customHeight="1" x14ac:dyDescent="0.15"/><row r="7" spans="1:1" x14ac:dyDescent="0.15"><c r="A7" t="s"><v>4</v></c></row></sheetData><pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3"/></worksheet>
The information above provides data about the width and height for every cell with data (interestingly, for cells without data width and height above formatting is still preserved when closing and opening the excel sheet but I cannot find it anywhere in the xml files generated during decompression).
I was wondering if the above data is already easily accessible in the package?
To be more precise, I would like to find out the exact position of the text content within a cell but I guess this data is not readily available and would need the width and height of a cell, as well as font size and alignment to do that;
Thanks!
Beta Was this translation helpful? Give feedback.
All reactions