How read XLSX file without office automation?
-
Hi , can u please help me to read XLSX file without office automation i read XLS file using ODBC Driver. but XLSX file read by this driver not found please help me how can do this. thanks for any help and guidance in advance
[Xlsx files - Microsoft.ACE.OLEDB.12.0 - ConnectionStrings.com](https://www.connectionstrings.com/ace-oledb-12-0/xlsx-files/) [Excel connection strings - ConnectionStrings.com](https://www.connectionstrings.com/excel/)
-
Hi , can u please help me to read XLSX file without office automation i read XLS file using ODBC Driver. but XLSX file read by this driver not found please help me how can do this. thanks for any help and guidance in advance
Edit: Ignore this - I thought it was a C# question. :-O Original message - for .NET only: I'd recommend EPPlus: GitHub - JanKallman/EPPlus: Create advanced Excel spreadsheets using .NET[^] There's also ClosedXML: GitHub - ClosedXML/ClosedXML: ClosedXML is a .NET library for reading, manipulating and writing Excel 2007+ (.xlsx, .xlsm) files. It aims to provide an intuitive and user-friendly interface to dealing with the underlying OpenXML API.[^] Or the Open XML SDK: GitHub - OfficeDev/Open-XML-SDK: Open XML SDK by Microsoft[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
Edit: Ignore this - I thought it was a C# question. :-O Original message - for .NET only: I'd recommend EPPlus: GitHub - JanKallman/EPPlus: Create advanced Excel spreadsheets using .NET[^] There's also ClosedXML: GitHub - ClosedXML/ClosedXML: ClosedXML is a .NET library for reading, manipulating and writing Excel 2007+ (.xlsx, .xlsm) files. It aims to provide an intuitive and user-friendly interface to dealing with the underlying OpenXML API.[^] Or the Open XML SDK: GitHub - OfficeDev/Open-XML-SDK: Open XML SDK by Microsoft[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
thanks for reply but i want to ask one thing these .Net dll can use in my mfc VC++ application.
Whoops! Sorry, I thought this was a C# question. :-O
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
Whoops! Sorry, I thought this was a C# question. :-O
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
Hi , can u please help me to read XLSX file without office automation i read XLS file using ODBC Driver. but XLSX file read by this driver not found please help me how can do this. thanks for any help and guidance in advance
In the past for just basic files I have used GitHub - brechtsanders/xlsxio: XLSX I/O - C library for reading and writing .xlsx files[^] Note the 3 limitations 1.) assumes the first row contains header names 2.) assumes the next rows contain values in the same columns as where the header names are supplied 3.) only values are processed, anything else is ignored (formulas, layout, graphics, charts, ...) CSV has easily become the more normal interchange and as its as simple as "save as" in excel it's rare anyone bothers with raw excel file anymore. They can do all there fancy graphs etc in excel itself and just export the data :-)
In vino veritas
-
Hi , can u please help me to read XLSX file without office automation i read XLS file using ODBC Driver. but XLSX file read by this driver not found please help me how can do this. thanks for any help and guidance in advance
Le@rner wrote:
...but XLSX file read by this driver not found
What exactly is this supposed to mean?
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles
-
Le@rner wrote:
...but XLSX file read by this driver not found
What exactly is this supposed to mean?
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles
It means what it says :-) He has a current version of Excel but the XLSX file is from and older version and that earlier driver isn't installed on the machine. Microsoft ODBC drivers simply call prior version drivers to load older version XLSX files they don't of themselves read older versions. The message is correct even if a bit humorous Now ask me the real funny question can you tell what version an xlsx file was created from :-) Well yeah if you have HexEditor the BIFF in the beginning of file header will have a tag XL9, XL10, XL12 etc. Find that old Driver, Download that driver, install and you are away .. simple for an end user hey
In vino veritas
-
It means what it says :-) He has a current version of Excel but the XLSX file is from and older version and that earlier driver isn't installed on the machine. Microsoft ODBC drivers simply call prior version drivers to load older version XLSX files they don't of themselves read older versions. The message is correct even if a bit humorous Now ask me the real funny question can you tell what version an xlsx file was created from :-) Well yeah if you have HexEditor the BIFF in the beginning of file header will have a tag XL9, XL10, XL12 etc. Find that old Driver, Download that driver, install and you are away .. simple for an end user hey
In vino veritas
-
In the past for just basic files I have used GitHub - brechtsanders/xlsxio: XLSX I/O - C library for reading and writing .xlsx files[^] Note the 3 limitations 1.) assumes the first row contains header names 2.) assumes the next rows contain values in the same columns as where the header names are supplied 3.) only values are processed, anything else is ignored (formulas, layout, graphics, charts, ...) CSV has easily become the more normal interchange and as its as simple as "save as" in excel it's rare anyone bothers with raw excel file anymore. They can do all there fancy graphs etc in excel itself and just export the data :-)
In vino veritas
