I m trying to add large number of rows to table. My Project has requirement for large table addition.  Please let me know if there is a better alternative to maximize performance. Should I use Range object API?  The code is as shown below.     functi...
I am looping through Sheet 1 of an Excel file which contains 3 columns with 100s of rows of data (strings) and comparing each cell in a row against rows of combinations in Sheet 2.  Checking should start using Sheet 1 row by row, seeing if each cell&...
I am trying to create xslx file using excel.js module in node.js. I was able to create the columns and add its values. But, I need to insert some rows before the columns headers, where I can have some descriptions. How can I do that?    Any help will...
plz help me.  My flow:     Using a file Tempate -> Code (Exceljs) -> output New file   Template file:   Center on page:   horizontally : Checked vertically : Checked   Source coder:  worksheet.pageSetup.horizontalCentered = true  worksheet.page...
I was using exceljs' sheet protection feature when I encountered an error–Error: Hash algorithm 'sha512' not supported!. After taking a look into it's source files I discovered the cause of the error: crypto.getHashes() is returning...
I wrote a script that creates a new excel file with ExcelJS. Adds 3 headers and inserts 2 rows. Then saves that file to disk.   In the next step it should read that previously saved file, add 1 row and save it again under a new name. I can't find...
I am working on Excel Web Add-In. I am using OfficeDev/office-js-helpers library for authenticating user. Following code is working fine. But I don't know how to get user's email, user name etc.  Is there any function available in OfficeDev/o...
I'm trying to format some data into a Excel table, I already have the data written in the Excel file, but I want it as a table, is there any way to do this, if not, is there any way with another npm package...
I am reading excel by using exceljs module. When my excel file in same folder. It works fine.  var workbook = new Excel.Workbook();  workbook.xlsx.readFile('Data.xls')     .then(function() {         var worksheet = workbook.getWorksheet(sheet...
Requirement is to export an excel file(*.xlsx) from ui-grid with some formatting. I am able to export the excel using angularjs, ui-grid and js-xlsx, however I am unable to format the excel cells (ex. bold, text color) with js-xlsx.   I found Exceljs...

Tags

Recent Questions

Top Questions

Home Tags Terms of Service Privacy Policy DMCA Contact Us

©2020 All rights reserved.