Forum Discussion

sarya's avatar
sarya
Frequent Contributor
16 years ago

Script Code not opening .xlsx files

Hi, I need to work with .xlsx files.I am using this code to open .xlsx files.It opens .xls files perfectly fine but not .xlsx files. In the local directory ,it creates a temporary .xlsx file al...
AlexeyKolosov's avatar
AlexeyKolosov
Icon for Staff rankStaff
16 years ago

Hi,


Replace the following line in the createInfo function:




  var rowObj = oSheet.Rows.Item(rowId);


with the line below:




  var rowObj = oSheet.UsedRange.Rows.Item(rowId);


Tell us whether it works.