All Questions
Tagged with excel javascript
3,039
questions
0
votes
0
answers
47
views
How to Upload Excel File in Node.js Using Express and Multer
I'm trying to upload an Excel file in my Node.js application using Express, Multer, and the XLSX library. I've put together the following setup, but I want to ensure I'm doing it correctly and ...
0
votes
0
answers
46
views
Excel VBA & IE : Input value to a prompt popup and enter
In short:
How do you 1. Focus on a prompt popup on IE, 2. Type in a value, and 3. Return?
In Long:
Hi,
I am trying to automate a login/file-downloading process on a company intranet server through VBA....
0
votes
0
answers
30
views
Populate an Excel file from SharePoint list items
I want to ask how to create a flow where it extracts the data from a SharePoint list to populate an Excel file. The SharePoint List is an expense claim submitted and approved by employees and managers....
-1
votes
0
answers
55
views
How do I add a dropdown options list in Exceljs?
I have a dropdown list in excel but exceljs isn't recognizing it when I import it. Is there some function I need to call to process formulae?
Here's my svelte component which isn't handling dropdowns ...
0
votes
0
answers
29
views
Excel formatting (RowSpan) messed up
I am exporting a HTML Table using this below.
var template = `<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns=&...
1
vote
1
answer
31
views
Check cell type using xlsx package
I have an excel file like this:
I use xlsx to parse a sheet's data to json:
import * as XLSX from 'xlsx';
const wb = XLSX.read(data, { type: 'binary' });
const ws = wb.Sheets['Sheet'];
const json = ...
0
votes
1
answer
43
views
Javascript and Excel DB
I made a Javascript nodejs project that stores data in Excel.
I can access all columns in the entire file without any problems, but the value of the cells containing time information(12:30) is given ...
0
votes
0
answers
29
views
ExcelJS RichText weird behaviour
I'm working on a Node.js project to parse an Excel file. My goal is to retrieve all cells where the text is in bold or italic. However, I'm encountering a strange issue.
Here’s what my Excel file ...
-1
votes
1
answer
35
views
deleting rows via script very slow
Moving filtered rows from one worksheet to another in excel 365. I used the "Move Rows Between Tables" sample in the code editor. My source table is 40k rows with about 40 columns. I ...
0
votes
1
answer
53
views
export to excel using datatable
I want to export to excel. here is my code.
$('#tabelku').dataTable({
dom: 'Bfrtip',
"buttons": [{
...
0
votes
0
answers
31
views
Getting around CORS with Excel Add In
Preface: I'm super new to CORS and this whole concept.
I'm building an Excel add in through which I want to call the unstructured.io api (https://api.unstructured.io/general/v0/general). However, ...
1
vote
0
answers
17
views
How to add dropdown to excel by javascript?
I want to automatic my excel-work-flow and I created some javascript to do my daily task. I need to implement dropdown with 3 options, and default none option.
I created this code, It correct add ...
0
votes
1
answer
31
views
SharePoint Copying Macro Enabled Excel File Using JavaScript
I have an Excel macro enabled file store in my SharePoint document library. Using JavaScript, I'm trying to essentially copy the file and create a duplicate of it with a different name for users to ...
0
votes
0
answers
46
views
Preserve cell/column formatting when adding rows in ExcelJs
I'm making a Next.js app but I've run into a problem.
The problem: I want to add some data into an Excel sheet which has a template. I'm currently using ExcelJs to do so. Adding data into the columns ...
0
votes
0
answers
25
views
Automatically running javascript Excel add-in code without manual approval
I want to implement a javascript add-in for Excel that automatically runs when I open any Excel file on my computer, without the need of the user to manually activate it and without opening any right ...