Hi,
I've several XLSB file reports with same format (12 month's Sheet name, and many sales report's Table name) just different value.
From each file I must extract specified table, e.g: in Sheet "May21" extract Table "SellOut" regularly.
Could I do this simple with Power Query formula/ function?
Regards,
Oswin
Hi Oswin,
Yes you can use Power Query to get data from a specific sheet and table in each file in a folder. I recommend you change the file format to .xlsx because you're likely to find it very slow with .xlsb files.
Mynda
Hi Mynda..
Very nice to meet you.
After I convert to .xlsx the problem still persists:
DataFormat.Error: The input couldn't be recognized as a valid Excel document.
Details:
Binary
How to solve this?
Just fyi,
"Step 3: Select Files" dialog box doesn't appear when I follow your steps:
https://www.myonlinetraininghub.com/power-query-get-files-from-a-folder
As far as I know, your solution in here:
https://www.myonlinetraininghub.com/excel-forum/power-query/import-data-from-excel-folder#p20762
is the best solution so far.. I just need more precision "Excel.Workbook" function, if any, to target specified "Table" and "Sheet"..
Sounds like the Excel file might have been generated by an external system and it hasn't been created in a proper Excel workbook format that Power Query can recognise. Did you try opening the .xlsb file and then File > Save As > .xlsx?
Mynda
