Title is what I'm trying to achieve. Basically I want to edit a existing excel sheet that is formatted with fonts/styles etc and keep those fonts/styles intact while changing a particular cells value.  I've tried using the xlsx npm module, I&...
I've got a nested json object. For the sake of simplicity:  data = {'key1': 1, 'key2': 2, 'key3': {'nestedKey1': 3, 'nestedKey2': 4}}   A real object is bigger but the point is that it's a nested one. V...
I'm using ExcelJS module and writing wrapper for my purposes, which implements Transform Stream API (yes, node version is 0.10.40).  ExcelJS has a stream API and according to example in ExcelJS module we can use one like this (execute node index....
I am trying to set a fixed column/cell width to my exported excel files with js-xlsx.  EDIT:  Here is the source of js-xlsx: https://github.com/SheetJS/js-xlsx...
I have an Excel file which has a big header at first and then two tables below. I tried to read it and get the details using js-xlsx but can't separate the data. I need to separately get some data from the header like the van number and dates. Th...
Im working on a project using Meteor in which i need to do some data parsing from given xlsx file into json. Actually i want some thing like that i upload a xlsx file it gives me data back in the form of json.  Since, Meteor is a nodejs framework so...
library(xlsx) write.xlsx(x = link.table, file = "actual1.xlsx",sheetName = "TestSheet", row.names = FALSE) save(link.table,file="actual.Rda")   I get this output:     library(xlsx)      write.xlsx(x = link.table, file = "a...
Thank you in advance for taking a look at this question! I am trying to use SheetJS to read a .xlsx file but am having some trouble with a column of dates that is formatted via Excel as Custom "yyyy/mm/dd hh:mm:ss".  All of these dates show u...
Can't find a way to style individual cells when writing to file. Reading is no problem though. Have tried either js-xlsx, xlsx-style, non seem to work? Or am I reading the API wrong?    If i read correctly it should be enough to set cell.s to an...
I want to launch a browser download of an excel file generated in my backend, but I can't figure how to pass that kind of response.  app.get('/all', function (req, res) {     db.query(...) LIMIT 20000;")     .then(function (data) {...

Tags

Recent Questions

Top Questions

Home Tags Terms of Service Privacy Policy DMCA Contact Us

©2020 All rights reserved.