W wl Well-Known Member Licensed User Longtime User May 14, 2022 #1 Hi, I would like to read an Excel sheet and have access to the style of a cell (borders, background color, ...). It seems when writing to xlsx you can SET styles (XLStyle), but is there also a way of READING them ? Thanks
Hi, I would like to read an Excel sheet and have access to the style of a cell (borders, background color, ...). It seems when writing to xlsx you can SET styles (XLStyle), but is there also a way of READING them ? Thanks
Erel B4X founder Staff member Licensed User Longtime User May 15, 2022 #2 Check the code in XLSheetWriter.FillStyleFromCell. It converts the existing cell style to a map with XLStyle keys. Upvote 0
Check the code in XLSheetWriter.FillStyleFromCell. It converts the existing cell style to a map with XLStyle keys.