Questions tagged [spreadjs]
SpreadJS is a comprehensive spreadsheet component for JavaScript. Powerful Excel Formula support, tables, data visualization, charts and more...
spreadjs
61
questions
0
votes
0
answers
31
views
Create an exact copy of my current excel with only values but not formulae using OfficeJS or any other 3rd party library
I am working on an excel with OfficeJS web addin. I have a fully loaded excel with data across different sheets and formulae.
I want to download an exact copy of the current workbook without formulae ,...
0
votes
0
answers
36
views
Display import data with spreadjs using web app
I am trying to display a table that has the following format but I don't know how to spread the columns out. The data is obtained through a json string with one column / object called vectors. The ...
0
votes
1
answer
73
views
org.openqa.selenium.JavascriptException: javascript error: window.testSpread.getActiveSheet is not a function
I'm trying to access the spreadjs canvas for one of my automation project with selenium java
This is code snippet I'm using for the same
URL: https://developer.mescius.com/spreadjs/demos/features/...
1
vote
0
answers
78
views
Unable to Load an xlsm file onto an existing excel workbook(.xlsx) with the help of SpreadJS using OfficeJS
I am working on an Web Addin for Excel using officeJS.
My requirement is to allow the user to select a file(.xlsm) from their local drive and load it onto the existing excel workbook as a new sheet.
I ...
0
votes
1
answer
53
views
Avoid pagebreak in merged rows or ranges in SpreadJS
I have a table with more than 1500 rows in SpreadJS, with many merged cells spanning multiple rows, but only in some columns.
When printing or exporting, I need to prevent pagebreaks inside the merged ...
0
votes
1
answer
303
views
How to open new SpreadJS file type of .sjs in a Blazor WASM application?
SpreadJS just released v16. How do I open the new file type of .sjs? This is a compressed/zipped file.
I tried creating a javascript Blob and passing this blob to spread.open(). See below.
...
0
votes
0
answers
430
views
How to locate HTML elements in SpreadJS
My company uses SpreadJS to embed an Excel like sheet into a web page. I'm trying to find a way to create automation tests for this, but I'm unable to locate any of the document information due to ...
0
votes
1
answer
316
views
Remove the filter arrows from the first row in a themed SpreadJS table
I am working with SpreadJS for the first time, and am busy wrapping my head around how the table styling works. I am theming to apply styles over the entire table, but there is a funny thing happening ...
0
votes
1
answer
474
views
Grapecity spread-sheets-pdf: savePDF() is not a function
Using NodeJs I'm trying to write a small API with Grapecity SpreadJs library.
In my project I have installed the following libraries:
"@grapecity/spread-excelio": "^14.2.0",
"...
-2
votes
1
answer
89
views
icons and some buttons of spreadjs is not working
in this image paste button,find button and some of the default buttons are not working
is there anything with the package that need to change, or which package is it for icons
1
vote
1
answer
349
views
Spread JS (GrapeCity) How to handler Sheet same name error
When I change same name for a sheet.
It appear unexpected message popup.
I don't sure about lib's bug or have custom in source code. But have any way to handler error(Spread JS GrapeCity ) message ...
0
votes
1
answer
252
views
How to Iterate through cells within particular columns
I have a spread sheet and I am trying to set a backColor for cells with empty values of some particular columns. Presently, I can iterate through the spread sheet and set the backColor for all cells ...
0
votes
1
answer
706
views
Import Array of JSON Data into spread JS
I am trying to import an array of object into spreadjs, I am using the fromJSON method but it doesnt get imported, my data is an array of object that looks like this
let jsonObj =
[{ 'name' : 'One',
...
0
votes
1
answer
474
views
Integrate SpreadJS in Oracle APEX
I am new to Oracle APEX, i am using apex version 21.1.0, i just want to upload excel file with password protected, so i have used Spread JS java script plugin, while i am trying to integrate i am ...
0
votes
1
answer
646
views
Trying to integrate SpreadJS Designer Component in a React Project
So I've been trying to integrate SpreadJS Designer Component (npm module) into my React project following this Quick Start guide for React. After trying for some time I got it to work like this, ...