Excel as Database giving a Data Table with null values

[praveen_satya (Praveen)]

Hi All,

I am trying to read Excel data using Excel as Database. I could able to get DataTable.

But i am getting null values in Datatable for report downloaded from SAP. I couldn’t able to understand what wen’t wrong.

Guys if any of you have found solution for this problem. Please let me know with your comments.

Regards,
Satya

[AnandKumar26 (Anand Kumar)]

@praveen_satya

I am trying to read Excel data using Excel as Database.

Hi @praveen_satya - Using Read Range? What would be your input format?

Regards,
AK

[praveen_satya (Praveen)]

Hi Anand,

I am getting an error when using Read Range with that Report. Please find below discussion Link.

Error while reading excel file using Workbook Read Range activity

Hi all, I am facing an error while trying to read an excel report downloaded from SAP having 71 Columns using Workbook Read Range. Source: Read Range Error Message: Row number must be between 1 and 1048576 Exception Type: System.IndexOutOfRangeException An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is: System.IndexOutOfRangeException: Row number must be between 1 and 1048576 at ClosedXML.Excel.XLWorksheet.Row(Int32 row, Boolean pingCells) in C:\Pro…

So, I am using Excel file to make a OLEDB connection and Executing a select query to get the Data. But it is returning me null values in DataTable. PFB snip.

[rohit_nirantar (Rohit)]

Did you get solution?

[satyapraveen.k]

Hi Rohit,

I have noticed that the file is getting corrupted. So i have copied the data from sheet 1 to another new excel file using invoke code activity with VB script.

Then with the data in the new file i could able to read it and that has solved my issue.

Regards,
Satya.