Hello All, I have a script which reads the data from excel file interactively such that:
Where xlsname is the name of excel file. Now after calculations, I have to write the data in excel file. Now the calculations are based on selected data and user can select 3 rows, 30 rows or 300 rows.
Now I have written the data in excel as:
So if the data is not fo 1500 row, the remaining cells shows "NaN" values in output file. So what I want to put is
where n will be the length of data selected. is this possible? if yes then how?