Forum Discussion
Extract underlying Excel cell's format
I have difficulties finding Excel cell's underlying format via Power Query For example, several formatted cells which shows the amount and the Currency associated with each amount, where the form...
There is no native function in Power Query to achieve this, so you'd have to go down the rabbit hole and extract the xlsx to its pieces and then try to reassemble. You'll find a start to this procedure and some additional links in this blogpost: https://www.thebiccountant.com/2017/08/18/how-to-import-from-excel-with-cell-coordinates-in-power-query-and-power-bi/
Hi
Thanks for the reply.
I looked at the link you provided. As suggested, I looked at the replies, and notice one of them has sample Power Query code. I am still new to Power BI / Query, thus I may not understand fully the syntax.
Is there a Power Query function call that we can execute something like Excel.Sheet.Cell.NumberFormat? Or simply Cell.NumberFormat?
Thanks.