Create an empty spreadsheet

[jplevene]

Created a pqGrid and used code below to import a spreadsheet:

        pq.excel.importXl({ url: "https://paramquery.com/pro2/Content/workbook.xlsx" }, function (wb) {
            $("#grid").pqGrid("importWb", { workbook: wb, extraRows: 10, extraCols: 10 });
           $("#grid").pqGrid("hideLoading");
        });

How do I create an empty spreadsheet into my grid without loading an empty xlsx file?  Basically I want to open the grid and it is an empty spreadsheet ready to edit, etc.

SOLVED (See my reply)

[paramvir]

Empty workbook can be used instead of empty xlsx file and extraRows, extraCols parameters can be used to add empty rows and columns.

Code: [Select]

var wb = {
      sheets: [
        {
          rows: [
          ],         
          columns: [         
          ]
        }
      ]
    }

    //import workbook into the grid.
    grid.importWb({ workbook: wb, extraRows: 20, extraCols: 10 });


[jplevene]

I did it by:

Code: [Select]

$("#grid").pqGrid("importWb", { sheet:0, workbook:{sheets:[{}]}, extraRows: 10, extraCols: 10 })