is it possible to upload data of .xslx file to Quickbase table using API? is there any quickbase API to do this ?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I want to upload data from Excel file to Quickbase table using Jquery.


Kindly let me know is there any quickbase API is there to do this or which Jquery or Javascript library we can use for this.
Photo of shyam

shyam

  • 20 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,204 Points 20k badge 2x thumb
Yes it is possible using script and an appropriate library. See:

Parse and Read Excel Files (xls/xlsx) With JavaScript
http://codetheory.in/parse-read-excel-files-xls-xlsx-javascript/

How to parse Excel file in Javascript/HTML5
http://stackoverflow.com/questions/8238407/how-to-parse-excel-file-in-javascript-html5

A library will greatly simplify the task but take note of the advice in the second link: "the general task of parsing XLS files from javascript is tedious and difficult but not impossible."
I think you may be better off preparing you data for importing outside of QuickBase. An random Excel file can contain a lot of heterogeneous data that could well trip up a simple minded CSV extraction strategy. You may well not encounter a problem until you have selected a library and are well into development. If you need assistance implementing this solution fee free to contact me using the information in my profile:

https://quickbase-community.intuit.com/users/513/