[FREE] ExcelTool a tool for working with xls files (Excel 97-2003 type)

Hello everyone I’m sharing my new extension called ExcelTool.
To implement this extension
With this extension, you can directly read or write cells in Excel spreadsheets.
To implement this idea, I used the library jxl.jar (A Java library for reading/writing Excel - Browse Files at SourceForge.net if anyone would be interested)
The library has its own weight, so the extension is not small. Due to the library’s features, the extension works with XLS files, but not with XLSX files. To work with the latter type of files, you need to attach an even larger library, which is completely unjustified.
One more time. the extension works with XLS files (Excel 97-2003 format)

now briefly on the expansion blocks with examples:
Read
filePath - the full path to the file. the example uses a third-party extension.
ListName- the name of the sheet in the table.
row , col - the requested cell
write
filePath - the full path to the file. the example uses a third-party extension.
ListName- the name of the sheet in the table.
row , col - cell coordinates
value the write value
listsname
array of values of all sheets in the xls file

searches for the specified value in the file. the result is reflected in the event. the format of the record will mean the coordinates of the cell. (for example 1-2 means row=1 and col=2)
exacMatch search for a complete match (true) or anything that contains the specified value partially (false)


converts file data to csv format

converts file data csv to xls file (excel format)

image
SearcResult event if there is no search result (does not find a value or text) returns the value 0 or the coordinates of the found value (array)

if you have any questions, write in the comments. I tried to make the extensions very clear :slight_smile:

download:
version 1:ExcelTool.aix (918.1 KB)
version 2:ExcelTool_v2.aix (918.4 KB)

5 Likes

Good job @11119

Looks great, congratulations!

However the example screenshots do not make much sense, because files in the assets are read-only after building the app…

Taifun

2 Likes

nice work :heart:

1 Like

Wow Thank you

version 2. Added the function of creating an xls file

Screenshot_2

ExcelTool_v2.aix (918.4 KB)

3 Likes

If you are using rush, you can use rush build -o to reduce size of extension, i think (918.4 KB) is so big

unfortunately
, the extension based on this library could not be reduced. She’s all involved there.

1 Like