_XLSXReadToArray (using only Autoit)

[Melba23]

fenhanxue,

When you reply, please use the "Reply to this topic" button at the top of the thread or the "Reply to this topic" editor at the bottom rather than the "Quote" button. Quoting entire posts just pads the thread unnecessarily. Thanks in advance for your future cooperation.

M23

 

[fenhanxue]

15 minutes ago, BrewManNH said:

Post the script you're using.

my code is as follow:

#include <Array.au3>
#include <_XLSXReadToArray.au3>
    
$temp_new_create = @ScriptDir&'\111.xlsx'

local $a, $t, $Error, $Extended
$t = TimerInit()

$a = _XLSXReadToArray($temp_new_create, 1, 0, 0)
$t = TimerDiff($t)
_ArrayDisplay($a, $t)
    

exit

 

and the result is as show below:

 

111.xlsx

[fenhanxue]

sorry Melba23

I'm really sorry, I'll pay attention to it next time

[Dana]

I know this is an old thread, and the OP hasn't been seen here in some years, but... is anybody still using this UDF?

When I use it to convert a downloaded .xlsx file, the top row of the file (line 2 in the resultant array) is blank.  I've figured out that it's due to the use of bolt font for the top row (column names).  If I open the file in Excel, unbold the top row, and resave, that line imports correctly... but I can't count on the user having Office to do this.  I haven't looked closely at the UDF code yet, has anybody else run into this?  Or have a better solution?

The file I'm using (which I have no control over) currently has 20004 rows and 104 columns.  I actually only need 5 of those columns, but I do need the column names.  My script worked great until the data provider changed the format from csv (even though they gave it a .xls extension) to .xlsx.