Category: Windows

21 Feb 2017 12:20

Joined:	17/07/2011
Level:	Silver
Points:	106

Points:	5

Read XLXS file import into datatable

I am working on excel file, Read Excel file and import excel file data into datatable. It is working proper in case of XLS even one column value has(Example:TA123,AB678) but when i am using the XLSX extension then read XLXS file that time (Example:TA123,AB678) which rows has this type of code then it is showing blank column.

I have already used this connection string:

1. conn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties='Excel 12.0;HDR=YES';";
2. conn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties='Excel 12.0;HDR=YES';IMEX=1\"";

But not woring

#768906

21 Feb 2017 14:02

Joined:	03/05/2013
Level:	Gold
Points:	15822

Points:	2

Hi nitin,

Have you got any error, as I seen your connection is OK I suggest you to please check by debugging your code. If you got any error then let me know based on that we come to know the issue.

--------------------------------------------------------------------------------
Give respect to your work, Instead of trying to impress your boss.

N@veen
Blog : http://naveens-dotnet.blogspot.in/

#768907

21 Feb 2017 14:54

Joined:	17/07/2011
Level:	Silver
Points:	106

Points:	1

In this screen shoot RS_ClientID is blank where Numeric number and character.
Example:TA123,AB678

RS_ClientID row is blank.

PrintScreen.docx

Delete Attachment

#768908

21 Feb 2017 15:31

Joined:	03/05/2013
Level:	Gold
Points:	15822

Points:	2

Hi,

Only problem with Numeric field means there is no problem with .xlsx, their might be different issue, please debug the code why numeric field is missed out while retrieve time, looping each entry...

--------------------------------------------------------------------------------
Give respect to your work, Instead of trying to impress your boss.

N@veen
Blog : http://naveens-dotnet.blogspot.in/

#768909

22 Feb 2017 07:59

Joined:	15/02/2016
Level:	Bronze
Points:	75

Points:	2

Hi,

You could also use Free Spire.XLS to achieve this task, which is pure and easy to use.
https://www.nuget.org/packages/FreeSpire.XLS/
Reference:
https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Import/Export-Import-Data-from-Excel-to-Datatable.html

#768916

22 Feb 2017 15:07

Joined:	28/04/2006
Level:	Gold
Points:	29773

Points:	3

Hai Nitin,
This should work as the code is common for all the xlsx files. While reading, check the value is coming when you are building the data table. If the value is not coming, then check the type which you have mentioned for the data-table. Sometimes, the type mismatch will not get the data from the excel file.
Hope it will be helpful to you.

Regards,
Pawan Awasthi(DNS MVM)
+91 8123489140 (whatsApp), +60 14365 1476(Malaysia)
pawansoftit@gmail.com

Read XLXS file import into datatable

About dotnetspider.com

Quick Links

General

Services