2

Are there any functions or methods in smartsheet API 1.1 that allow you to create a new sheet or update an existing sheet based on an csv or xml file?

Kim Brandl
  • 13,125
  • 2
  • 16
  • 21
T A
  • 63
  • 1
  • 6

2 Answers2

1

At this time the Smartsheet API does not have a method to import a CSV or XML File.

However, you can import the CSV in the Smartsheet application. More info here

Also, you can use a Java library to read the CSV or XML file and then issue the appropriate API calls to create a new sheet and insert the rows. This can be done more efficiently using the 2.0 version of the Smartsheet API.

Brett
  • 2,502
  • 19
  • 30
  • I could only find the SDK's for the API 1.1 as they have not been changed to handle the 2.0 yet according to github. – T A Aug 10 '15 at 12:27
  • You are in luck, Smartsheet just released a new version of the SDK that uses API 2.0. You can download the Java SDK by updating your Maven pom to point to version 2.0.0. https://github.com/smartsheet-platform/smartsheet-java-sdk – Brett Aug 13 '15 at 20:05
1

There is way to do this now in version 2.2.0. Only XLSX file is supported.

Sheet sheet = smartsheet.SheetResources.ImportXlsSheet("SampleSheet.xlsx", null, 0, null);
sheet = smartsheet.SheetResources.GetSheet(sheet.Id.Value, null, null, null, null, null, null, null);
Vishal V
  • 215
  • 1
  • 8