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

Fabrice

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 :

https://smartsheet.redoc.ly/tag/import/

curl  https://api.smartsheet.com/2.0/folders/{folderId}/sheets/import?sheetName=MarketingProgressReport&headerRowIndex=0&primaryColumnIndex=0 \
-H "Authorization: Bearer JKlMNOpQ12RStUVwxYZAbcde3F5g6hijklM789" \
-H "Content-Disposition: attachment" \
-H "Content-Type: text/csv" \
-X POST \
--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

jmyzk_cloudsmart_jp

Hi @Fabrice

I have also identified such a problem when importing a grouped Excel sheet into Smartsheet using the API and specifying a Header Row.

Here is the Python function code to fix this problem

• First, import with header_row_index=None.
• Next, update the Columns of the sheet with the values of the header_row cells.
• Finally, delete the unnecessary rows.

https://gist.github.com/jmyzk/fc19c95a8da132aa624a33c0a50bfd86

jmyzk_cloudsmart_jp

Hi @Fabrice

I have also identified such a problem when importing a grouped Excel sheet into Smartsheet using the API and specifying a Header Row.

Here is the Python function code to fix this problem

• First, import with header_row_index=None.
• Next, update the Columns of the sheet with the values of the header_row cells.
• Finally, delete the unnecessary rows.

https://gist.github.com/jmyzk/fc19c95a8da132aa624a33c0a50bfd86

Fabrice

Hi @Junichiro

Thx for this answer and the link with the fix code 👍️

I developped also my side such a python function: It is functionnal, but it slows down a lot the import when you have a lot of column. (each column update takes about 1 sec)

I Also opened a ticket with smartsheet Support for this issue, i hope smartsheet will fix the issue !

kind regards

Fabrice

jmyzk_cloudsmart_jp

https://gist.github.com/jmyzk/6573efc44d03a3f04d29c58a9d5b82ec