@Axel Vogt 

Hello,

sorry, try this

https://mega.nz/file/rTxXyKjY#gX0-XG1WRIIVJ-6JhD4-GN8lCH6z7xOSz1hrLNGk3KA

for downloading the two Excel files.

I think there is a problem for Maple to import large Excel files (Maple 2020)

Thanks

@Axel Vogt 

@CR 

Thanks at all, but...

I continue to have problems with importing large Excel (and csv) files.
Even if I "clean everything up", I delete the first column of the date and try to make an import of a large Excel file both with the assistant and with the import command I have the usual error:

Error, (in Import) invalid input: MatrixToDataFrame uses a 3rd argument, columns, which is missing

A slightly smaller file taken from it with 1000 lines less does not give an error.
So I think there is an import problem for very large Excel files that contain data and strings.
I  cannot load them from here because they are too large and the system does not accept them, i paste the link for download a zip file with the OK and KO file.

The link for download files:

https://www.asuswebstorage.com/navigate/a/#/s/8DEC778441D147FEAB8154E736E325914

thanks a lot

@Axel Vogt 

Hello, thanks. If i use the Excel file with data/time i have this error :

Error, (in Import) invalid input: MatrixToDataFrame uses a 3rd argument, columns, which is missing

As indicated I think it is due to the date format which is European in my Excel (dd / mm / yy hh: mm: ss)
but even if I set my Windows in USA format save the Excel file ed import to Maple the error remains the same.
It therefore seems to me that the language and number and date format settings natively set on Windows are not used correctly by Maple, in practice it does not manage the localization, but even if the USA format is imposed from Windows and the Excel file is saved, so the error is the same.
I therefore have the impossibility for now to use this type of data.
If there are alternatives, thank you.

@tomleslie Maple_test_csv.zip

Hello, i don't know why there is that error, i have rezipped the two csv files.

@tomleslie 

Hello, attached two screenshot of the Maple output for explain.

The Sub1 is wrong, the test1 is right.

Output_Maple_csv.zip

Thanks, regards

@Carl Love plantdata.zip

Sorry...

@Axel Vogt 

hello, thanks,

Now it seems to work, I will try with other similar files that give the same problem.
I must then convert the first column to date, as it is in the original Excel file, I saw that on is correctly interpreted as a date but converted into a generic numeric field

Regards

@Axel Vogt 

Hello, changed from Italy to US, but same error

Error, (in Import) invalid input: MatrixToDataFrame uses a 3rd argument, columns, which is missing

@Scot Gould 

Hello,

i use this command

restart;
with(Statistics);

plantdata := Import(FileTools:-JoinPath(["d:", "dati", "Prove", "Maple", "Subset_test.xlsx"], platform = "windows"));

Attached the zipped Excel fileSubset_test.zip

so, i think "generic" import.

i test also with Excel import but i have error

I need import an Excel table with first line is column label, for performing data analysis.

thanks, regards