Free Support Forum - aspose.com

Issue with excel generated to use in MS Power Query

Hi Team,

We are facing a issue where aspose generated files doesn’t retrieve any data while using it in Microsoft Power Query.
I have attached few files for your reference. Let us know if you need more information.
MS Excel Power Query.zip (3.2 MB)

@sukesh.kotian,

Thanks for your query.

We have tried to re-produce the issue using Excel 2016, but could not identify any difference between ‘Reports List.xlsx’ and ‘Reports List MS Excel.xlsx’ while opened in MS Power Query. I am afraid that due to some reason the video was not clearly playedback at our system so it was not quite helpful for us. Please send us static images where issue is identified clearly as compared to the Excel created file. Also provide detailed steps to observe the problem.

For your reference two snapshots are attached which are taken while opening both the files in MS Power Query.
Reports List.PNG (100.6 KB)
Reports List MS Excel.PNG (100.3 KB)

@ahsaniqbalsidiqui

Sorry for the file mixup, Please check the attached files now. You can see the same file generated from Aspose and MS Excel are different in size.
Reports List.zip (432.4 KB)

@sukesh.kotian,

We are able to observe the problem using this new file “Reports List.xlsx”. Now we need the simplest console application (runnable) which can be used to create a file similar to “Reports List.xlsx” but containing minimum data to reproduce issue. Also please share the steps to create a file similar to “Reports List MS Excel.xlsx” using Excel but containing minimum data for comparison with the file created by Aspose.Cells.

This information will help us to create this file here and then check it in MS Power Query Editor.

@ahsaniqbalsidiqui

We are using LightCellsDataProvider to generate “Reports List.xlsx”
For “Reports List MS Excel.xlsx” , i just used Save as option in excel on “Reports List.xlsx”

@sukesh.kotian,

Thanks for providing information. We can observe the issue where Reports List.xlsx file does not show data in MS Power Query, however if we open same file in Excel and save it back on disc, the data is visible in MS Power Query.

It is also suggested that you should not use LightCells APIs to generate such a report containing Pivot table or using Power query. Please generate the report in normal mode and do not use LightCells APIs and give us feedback. LightCells APIs is used for simple reading or write huge list of data, other objects or element of spreadsheet might be discarded when using LightCells APIs.

We need your updated sample application(runnable) for creating this file here as per above suggestion and identifying the issue. Please send us simple console application for our analysis.