Log In
Register
Home
Active Member
May 31, 2021
Offline
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
July 16, 2010
Offline
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
Active Member
May 31, 2021
Offline
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.myonlinetraininghu.....m-a-folder
As far as I know, your solution in here:
https://www.myonlinetraininghu.....der#p20762
is the best solution so far.. I just need more precision "Excel.Workbook" function, if any, to target specified "Table" and "Sheet"..
July 16, 2010
Offline
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
1 Guest(s)
