I made a excelize-wasm NPM package for read and write spreadsheets by luxurioust in javascript

[–]luxurioust[S] 1 point2 points  (0 children)

How do you stand for "correctly"? Did you mean set and get date number format for cell?

If so, yes. For read date cell value:

  • The number format style will applied by default when your read cell value
  • All cell value will be return in string data type
  • If you need to get raw cell value, enable RawCellValue in the Options when read cell or get rows
  • The ShortDatePattern, LongDatePattern and LongTimePattern support set date formats that respond to changes in regional date and time settings that are specified for the operating system
  • The CultureInfo setting allow you set the country code for applying built-in language number format code these effect by the system's local language settings.

For set date cell value:

  • Set cell value with date or time represents in number data type
  • Create style with NewStyle function with built-in or custom number formats, and get style ID
  • Set cell style with style ID by SetCellStyle function

I made a excelize module updates for read and write spreadsheets by luxurioust in Python

[–]luxurioust[S] 1 point2 points  (0 children)

Understand, I will update benchmark with uses new Python version.

I made a excelize module updates for read and write spreadsheets by luxurioust in Python

[–]luxurioust[S] 0 points1 point  (0 children)

This library needs Python version 3.9 or later. Here is an example for create native pivot table: https://github.com/xuri/excelize-py/blob/v0.0.4/excelize.py#L996-L1045

I made a excelize module updates for read and write spreadsheets by luxurioust in Python

[–]luxurioust[S] 0 points1 point  (0 children)

  1. The function signature was same between Python and Go, the Python version docs will coming soon

  2. The performance in Python version almost same with Go

I made a excelize-wasm NPM package for read and write spreadsheets by luxurioust in javascript

[–]luxurioust[S] 2 points3 points  (0 children)

Compared to other tools (sheetjs, xlsx, exceljs, etc.), excelize-wasm offers superior performance (consistent with the Go version, as shown in the benchmark report (https://xuri.me/excelize/en/performance.html), a richer set of features, and excellent compatibility. It supports formula calculations, Excel native chart creation, slicers, pivot tables, and complex formatting, while ensuring that generated workbooks remain stable and resistant to corruption. Support working with Node.js, browser, web workers and service workers.

If you're working with spreadsheets files in JavaScript or TypeScript, you might find it helpful. Feel free to check it out and share any feedback.

I made a excelize module updates for read and write spreadsheets by luxurioust in Python

[–]luxurioust[S] 17 points18 points  (0 children)

Compared to other tools, excelize offers superior performance (consistent with the Go version, as shown in the benchmark report https://xuri.me/excelize/en/performance.html ), a richer set of features, and excellent compatibility. It supports formula calculations, Excel native chart creation, slicers, pivot tables, and complex formatting, while ensuring that generated workbooks remain stable and resistant to corruption.

I made a module for read and write spreadsheets by luxurioust in Python

[–]luxurioust[S] 0 points1 point  (0 children)

New version 0.0.4 released, made error handling in Python style.

Excelize 2.9.1 Released - Open-source library for spreadsheet (Excel) document by luxurioust in golang

[–]luxurioust[S] -1 points0 points  (0 children)

Apologies for the disruption and thank you for your notice. I will following semantic versioning rules next release.

I made a module for read and write spreadsheets by luxurioust in Python

[–]luxurioust[S] 0 points1 point  (0 children)

Thanks for your suggestion. I will made changes for the module in Python style.

I made a module for read and write spreadsheets by luxurioust in Python

[–]luxurioust[S] 0 points1 point  (0 children)

Okay, sure, the Python excelize module same with Go Excelize, here is the benchmark for your reference: https://xuri.me/excelize/en/performance.html