Hi All,
Hope you are doing good.
I have an excel sheet containing a set of data wherein i wish to read only a specific set of rows. Test Excel.xlsx
In my case, i wish to read the data below the string (in mass percent) in row 280 from 281 to 296 with 281 as the column names. The whole table is supposed to be read below the above mentioned string. These row numbers may change with different excel sheets. So i need a generalized solution.
Please help. Thanks.
Hi @asabhinavgreats Will the field names always be Carbon, Para, Iso, and Fin? You could read the Excel file, use a Tester to find where column A = (in mass percent), then use an AttributeManager to assign values of columns A-D to Carbon, Para, Iso, and Fin. Continue testing until 'Grand Total:' is found in column A.
Here's a solution using VariableSetters and VariableRetrievers
Hi @asabhinavgreats Will the field names always be Carbon, Para, Iso, and Fin? You could read the Excel file, use a Tester to find where column A = (in mass percent), then use an AttributeManager to assign values of columns A-D to Carbon, Para, Iso, and Fin. Continue testing until 'Grand Total:' is found in column A.
Here's a solution using VariableSetters and VariableRetrievers
Here's a solution using VariableSetters and VariableRetrievers
Thanks Dan for the answer. I tried using your method and it worked.