The export function does not work in Bootstrap and Flexigrid themes. /assets/ grocery_crud/js/jquery_plugins/config/ Learn how to import and export Excel files, and provide users with an interface to “. Nice, sleek and intuitive. A grid control especially designed for bootstrap.
|Published (Last):||14 March 2007|
|PDF File Size:||17.5 Mb|
|ePub File Size:||13.47 Mb|
|Price:||Free* [*Free Regsitration Required]|
Sheets component, and a div element to contain it since the SpreadJS spreadsheet component utilizes a canvas, this is necessary to initialize the component:.
We need to create an instance of the client-side ExcelIO component that we can use to actually open the file:.
Then we need to add a function to import a file. In this example, we import a local file, but you can do the same thing with a file on a server.
The following is an example of an input element where the user can enter the location of the file:. The following code for the import function just uses a local file for the “excelUrl” variable:. Now we can use Spread. Sheets script to add another revenue line into this file.
FlexGrid Import Export (JSZip2)
We can write a function for the click event handler for that button to add a row and copy the style from the previous row in preparation for adding some data. To copy the style, we will need to use the copyTo function and pass in:.
All of the following script code for adding data and a Sparkline will be contained within this button click event handler. For most of the data, we can use the setValue function. This allows us to set a value in a sheet in Spread by passing in a row index, column index, and value:.
Live Demos –
Lastly, we can copy the formulas from the previous rows to the new row for columns R through AD using the copyTo function again, this time using CopyToOptions. Now we can add a sparkline to match the other rows of data. To do this, we need to provide a range of cells to get the data from and some settings for the sparkline.
In this case, we can specify:. If you were to try running the code now, it might seem a little slow because the workbook is repainting every time data is changed and styles are added. To drastically speed it up and increase performance, Spread.
T provides the ability to suspend painting and the calculation service. Once we add that code, we can open the page in a web browser and see the Excel file load into Spread.
Sheets with an added revenue row. Alternatively, if you load a file from a website URL, it should open fine in any browser.
Flexigrid – Lightweight but rich data grid
Finally, we can add a button to export the file with the added row. To do this, we can use the client-side ExcelIO code built into Spread. That code gets the export file name from an exportFileName input element. We can define it and jqiery users name the file like so:. Once you add a revenue row, you can export the file using the Export File button.
Login to post a comment.