Quote from luishp on November 5, 2019, 7:50 pm

@asmat, as far as I know Excel files are in binary format.
Perhaps you can use LocalBinaryFileToVar command instead.

Quote from Gaev on November 5, 2019, 11:01 pm

@asmat

LocalFileToVar "FileInput1" [content]
Is there any way to import excel file like above into a variable?

If you (or user) are willing to perform one additional task, you can ...

1) Save (Export) the contents of your spreadsheet using File >>> Save As (inside Excel)
2) Use ...

a) LocalFileToVar "FileInput1" [content] to read contents of csv file into a variable
b) StrParse to separate the content of cells into array variables

OK if Excel is available on the same computer running your App ... and you don't need to transfer (changing) contents frequently.

Quote from asmat on November 6, 2019, 12:43 am

Hi @Gave,

I need to import .xlsx file into variable not csv file because, whenever i change the .xlsx file into .csv file with excel, the resulted csv file become damage which contain Persian language.

Hi luishp I have used this command:

LocalBinaryFileToVar "FileInput1" [content]

but, the result is like below.

Quote from luishp on November 6, 2019, 1:17 pm

@asmat, take a look here:

https://bossanova.uk/jexcel/v3/

This library is in my list to be adapted as a plugin.
I just need time...

Quote from Gaev on November 6, 2019, 4:04 pm

@asmat

whenever i change the .xlsx file into .csv file with excel, the resulted csv file become damage which contain Persian language.

The content on this page ... https://www.ablebits.com/office-addins-blog/2014/04/24/convert-excel-csv/ ... offers a work around for instances where "foreign-language contnet" messes up csv files ... i.e. save the data as a tab delimited (instead of comma separated) format ... Unicode Text (*.txt) ... see if it works for you.

Quote from asmat on November 6, 2019, 8:15 pm

Thank you Gaev, for sharing the above link ...

I have done the above way its work for me good.