ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel/XML File Limitations (https://www.excelbanter.com/excel-discussion-misc-queries/167998-excel-xml-file-limitations.html)

DaleB

Excel/XML File Limitations
 
Hi:

I am trying to import XML files into Excel (say one at a time), but many
of the XML files are large in size many GB. Does anyone know if there
isa size limitation in files for importing into Excel.

In other words...
Is there an upper limit in how big the source .xml file can be ?
Is there an upper limit in how big the target Excel .xls or .csv file can be ?
Is there an upper limit on the number of rows in an Excel Worksheet ?
Is there an upper limit on the number of columns in an Excel Worksheet ?
Is there an upper limit on the number of bytes within an Excel Worksheet
cell ?

Thank you...

DaleB




Bernard Liengme

Excel/XML File Limitations
 
Many (all?) of your questions are answered in the Help topic "Excel
specifications and limits" - search Help with the term <specs
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"DaleB" wrote in message
...
Hi:

I am trying to import XML files into Excel (say one at a time), but many
of the XML files are large in size many GB. Does anyone know if there
isa size limitation in files for importing into Excel.

In other words...
Is there an upper limit in how big the source .xml file can be ?
Is there an upper limit in how big the target Excel .xls or .csv file can
be ?
Is there an upper limit on the number of rows in an Excel Worksheet ?
Is there an upper limit on the number of columns in an Excel Worksheet ?
Is there an upper limit on the number of bytes within an Excel Worksheet
cell ?

Thank you...

DaleB






DaleB

Excel/XML File Limitations
 
Thanx !

"Bernard Liengme" wrote:

Many (all?) of your questions are answered in the Help topic "Excel
specifications and limits" - search Help with the term <specs
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"DaleB" wrote in message
...
Hi:

I am trying to import XML files into Excel (say one at a time), but many
of the XML files are large in size many GB. Does anyone know if there
isa size limitation in files for importing into Excel.

In other words...
Is there an upper limit in how big the source .xml file can be ?
Is there an upper limit in how big the target Excel .xls or .csv file can
be ?
Is there an upper limit on the number of rows in an Excel Worksheet ?
Is there an upper limit on the number of columns in an Excel Worksheet ?
Is there an upper limit on the number of bytes within an Excel Worksheet
cell ?

Thank you...

DaleB








All times are GMT +1. The time now is 02:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com