Issue When importing an EXCEL file with API ? (switched indent !!)

Fabrice ✭✭✭
edited 06/14/23 in API & Developers

Hi all,

I have a question about what seems to be an issue in smartsheet API.

I am surprised not to have found this bug in the forums because the Excel import in smartsheet must be very used?

Here is the issue :

When you import an Excel file containing indentation, with this script :

curl{folderId}/sheets/import?sheetName=MarketingProgressReport&headerRowIndex=0&primaryColumnIndex=0 \
-H "Authorization: Bearer JKlMNOpQ12RStUVwxYZAbcde3F5g6hijklM789" \
-H "Content-Disposition: attachment" \
-H "Content-Type: text/csv" \
--data-binary @ProgressReport.csv

Then, all the indentation are switched, ONLY when you use the headerRowIndex=0 Option, to set the column title with the first Row, see below.

Any idea ? did i miss something ?

Thx for your help

Best Answer