Excluding a specific row from an Excel spread sheet

[Anonymous]

Hello,

I have an Excel spread sheet that I am loading my data from. It has multiple rows and columns. The very last row in the spread sheet is a totals row, where all the data from the columns is summed up. When making graphs this row skews the results, so is there any way to take it out using the script? Or is it best to just remove the row from the spreadsheet all together?

Thank you for you help,

- Joe

[#2 · Accepted solution]

Hi Joe,

You can remove the row by including a where clause in the script.

In my case the label for the total row is 'total'

Go to File>Edit Script

insert the where clause prior to the ;

e.g.

LOAD A,

     B

FROM

D:\datawithtotal.xls.xlsx

(ooxml, no labels)

where A<>'total';

hope this helps,

[Anonymous]

Thank you! My problem was I didn't realize that pesky semi-colon was the end of the script so when I tried to type in WHERE before it gave me problems. Thank you for your help!