Skip to main content

Node.js/Angular: SheetJS js-xlsx library with issues and fixes.

In this article, we will see how SheetJS js-xlsx library
is used to export  data to xlsx file for a particular use case and
also, I am covering a few issues that I found and fixes for that.

So let's start without wasting time,


Use Case: We need to export a html table (containing all columns and rows) into xlsx file.

Angular Example Link: https://stackblitz.com/edit/angular-xbgicw?file=app%2Fapp.component.ts

I have used the reference of this example in this article.
So please check the Angular Example Link.

Here, I have 2 tables with 3 columns Name, Dob in dd/mm/yyyy format, and
Id which is a string but sometimes its value maybe number 20 digit.

So let's see the happy case:

In this example I have imported xlsx library and has 2 functions importTable1() and importTable2()
which use xlsx util functions to export the tables into xlsx files.

Issues Found:
(Export Table One  button will export xlsx sheet for table1 which has these issues)

1) When you export the sheet for table one using xlsx library the
 Dob column format changes into mm/dd/yyyy if the date value is less or equal to 12.
For example :
Dob for Rubecca in table one is 11/10/1998 and if you export
table one you will see it changed to 10/11/1998.

2) In Id column for table 1 for Zena is a 20 digit number.
  But when you export sheet for table 1 the Id value is round off.
For example Id value '10001000202020101010' is changed to '10001000202020100000'

Fixes:
In the reference example, I have given fixes for these 2 issues.
If you look at table 2, I have used "t='s'" inside <td> tag.
Which considers the respective column as string and does not manipulate value.
So when you click the Export Table Two button it will export xlsx sheet for table2 without any manipulations done to Id and Dob coloumn.

Npm package Link: https://www.npmjs.com/package/xlsx

You Might Like:

Node.js interview questions set 1

Node JS: Understanding bin in package.json.

Node.js: Bundling your Node.js application to a single executable for Windows.

Node.js: Extract text from image using Tesseract.


Comments

Post a Comment

Popular posts from this blog

Globant part 1

 1)call,apply,bind example? Ans: a. call Method: The call method is used to call a function with a given this value and arguments provided individually. Javascript code: function greet(name) {   console.log(`Hello, ${name}! I am ${this.role}.`); } const person = {   role: 'developer' }; greet.call(person, 'Alice'); // Output: Hello, Alice! I am developer. In this example, call invokes the greet function with person as the this value and passes 'Alice' as an argument. b. apply Method: The apply method is similar to call, but it accepts arguments as an array. Javascript code: function introduce(language1, language2) {   console.log(`I can code in ${language1} and ${language2}. I am ${this.name}.`); } const coder = {   name: 'Bob' }; introduce.apply(coder, ['JavaScript', 'Python']); // Output: I can code in JavaScript and Python. I am Bob. Here, apply is used to invoke introduce with coder as this and an array ['JavaScript', 'Pyt...
Post a Comment
Read more

Node.js: Extract text from image using Tesseract.

In this article, we will see how to extract text from images using Tesseract . So let's start with this use-case, Suppose you have 300 screenshot images in your mobile which has an email attribute that you need for some reason like growing your network or for email marketing. To get an email from all these images manually into CSV or excel will take a lot of time. So now we will check how to automate this thing. First, you need to install Tesseract OCR( An optical character recognition engine ) pre-built binary package for a particular OS. I have tested it for Windows 10. For Windows 10, you can install  it from here. For other OS you make check  this link. So once you install Tesseract from windows setup, you also need to set path variable probably, 'C:\Program Files\Tesseract-OCR' to access it from any location. Then you need to install textract library from npm. To read the path of these 300 images we can select all images and can rename it to som...
1 comment
Read more

CSS INTERVIEW QUESTIONS SET 2

  You make also like this CSS interview question set 1. Let's begin with set 2, 5)What is the difference between opacity 0 vs display none vs visibility hidden? Property           | occupies space | consumes clicks | +--------------------+----------------+-----------------+ | opacity: 0         |        yes      |        yes       | +--------------------+----------------+-----------------+ | visibility: hidden |        yes       |        no        | +--------------------+----------------+-----------------+ | display: none      |        no       |        no        | When we say it consumes click, that means it also consumes other pointer-events like onmousedown,onmousemove, etc. In e...
Post a Comment
Read more