Welcome to new things

[Technical] [Electronic work] [Gadget] [Game] memo writing

Excel

Sort Excel worksheets by name

I had the opportunity to work with Excel, which has hundreds of worksheets, and I tried to sort the worksheets by name because it was difficult to find the desired sheet. But Excel doesn't have the ability to sort worksheets by name. I end…

How to read CSV files with newlines and commas output by Excel in JavaScript

CSV files have been loaded using SheetJS. However, there was a CSV file that I just couldn't get to read properly because of garbled characters, so I decided to try another library. There was a library called "csv" that came up at the top …

Organize Tableau formatting to the extent that Excel-like graphs and tables can be drawn.

Tableau's default graphs are quite beautiful. For practical use, it is sufficient to slightly modify the defaults, but for graphs used for documentation purposes, you may want to change the appearance of the graphs in various ways to match…

Memo on how to read Excel files in JavaScript using SheetJS (xlsx)

I use SheetJS (xlsx) to load Excel files in JavaScript (TypeScript). The usage is a bit peculiar and I forget how to use it easily, so this is a memo for my own use. manual https://www.npmjs.com/package/xlsx install npm install xlsx File r…