How to use Excel Sheet in Linux Operating System

ismail

Hi,

Can you please let us know how to use to test Excel sheet in Linux OS.
I am using Linux V7.0 .


Thanks,
Ismail.

Sumitra

Hi Ismail,

If you are on Linux OS then use a CSV file instead of Excel, or use a real Excel JDBC driver, or parse the Excel yourself using Apache POI.

It is recommend to use CSV files for linux OS. There are API's to work with CSV files like:

_readCSVFile(csvFilePath) reads a CSV file and returns a two dimensional array.
_writeCSVFile(array2D, filePath) writes the two dimensional array into a file in CSV format.

If you want to work with excel sheet then here are the details:

http://sahi.co.in/w/working-with-excel-sheets

Let me know if you face any problem or if you need more information.

Regards
Sumitra

ismail

Thanks Sumitra... (:

But I want to use Excel sheet instead of CSV file in Linux OS.
Is it possible to use Excel sheet only.


Thanks,
Ismail.

rajukrishnan

Hi Simthra,

I have a registration form in my website, now i just wanted to create multiple users using sahi automation. I prefer sahi to take each row sets from an excel sheet where i have defined my test data.
can you guide me on this.

Regards,
Raju