- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Loading xls or xlsx files
Hi All,
While loading xls files, we use biff and while loading xlsx files, we use ooxml.
Is there a common format available for loading both xls and xlsx files
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Look here for explanation:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
When the files have the extension XLS or XLSX they have to be in that particular format BIFF or OOXML. So they go together always. You can't have a file name .XLS and not store it in BIFF-format. If you do it will be invalid/corrupt.
But you can translate your XLS-files into XLSX and then they turn from BIFF into OOXML and vice versa - the latter with the risk of losing functionality but probably not any data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you have influence to the file-fomat you should avoid xlsx as format then it's far away from optimized and loading from these files is very slow compared to xls or txt/csv-files.
To handle different file-formats within a folder you could use filelist in a loop: Loops in the Script.
- Marcus
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Asma,
You can use this function:
LET vPath = 'C:\user\test\documents\teste.xls';
LET vExtension = Mid('$(vPath)', Index('$(vPath)', '.xls'), len('$(vPath)'));
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Why is .xlsx slower than .xls?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
xls is a proprietary binary file-format and xlsx is an "open" xml file-format which is more structured and had more overhead for it. In my experience xlsx needs significantly longer run-times as xls whereby if possible I avoid both formats and store the data as simple txt-files.
- Marcus
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Ah gotcha, thank you!