Hello,
I'm using excel plugin tools and i can read excel databut i don't need null of row so i want to delete null row.I tried to loop list of text string but cannot get it.How can i convert list of text string to list.
here is my test rest of screen shot
here is my excel data image
Discussion posts and replies are publicly visible
Hello spykid
Please share the code which would help us update a little and reshare. You can try using reject function and check.
You won't be able to "delete" anything. You can clean up your results in various ways, but it depends on what you want. Do you just want all non-null values? Do you want to exclude just rows that contain all nulls (but not exclude ones that contain any data even if mixed with SOME nulls)? It's pretty unclear here what you're starting with and what you're after, so it's hard to make any definitive recommendations.
There is a new plugin available, with better features called "excel utilities", you can use below function under that.
readexcelsheetwithfilter(excelDocument, sheetNumber, startRow, endRow, startColumn, endColumn, rejectNullRowsAndColumns, password)
A function to read data from an Excel sheet in a paged way.
Returns: DataSubset
excelDocument (Document): The Excel document to read from. The provided excel file should be of .xlsx extension.
sheetNumber (Number (Integer)): The sheet number to read from, Where 1 is the first sheet, 2 is the second sheet, etc.
startRow (Number (Integer)): Provide the starting row index from where the data should be read. Index starts from 1.
endRow (Number (Integer)): Provide the ending row index up to which the data should be read. Provide null() to get all rows in the sheet.
startColumn (Number (Integer)): Provide the starting Column index from where the data should be read. Index starts from 1.
endColumn (Number (Integer)): Provide the ending Column index up to which the data should be read. Provide null() to get all column in the sheet.
rejectNullRowsAndColumns (Boolean): Optional: Provide true to reject the empty rows and columns in the sheet when getting the output data. Default: false.
password (Text): Optional: Password for the provided excel document when the document is password protected.
karthikkanjerla
Thank for your information. I will try "excel utilities" plugin
I tried "excel utilities" plugin . but i got a error
How many number of Sheets do you have in the excel file?If only One try having 0 for the sheetNumber parameter.
2 sheets in the excel file . Changed sheet nunber but still got a error
Which version is your Plug-in? is it the latest one?
Konduru Chaitanya
using version 4.2.2
Mike Schmitt
I want to read an excel file and check the contents of the excel file. I want to retrieve only rows that have values.I was able to load excel file and i'm trying to check the contents of the excel file using a loop, but I can't..
How can i clean up my excel file result