Skip to content

Update xlsx table - #316

Merged
houqp merged 1 commit into
roapi:mainfrom
Maks-D:excel_table
Feb 1, 2024
Merged

Update xlsx table#316
houqp merged 1 commit into
roapi:mainfrom
Maks-D:excel_table

Conversation

@Maks-D

@Maks-D Maks-D commented Jan 7, 2024

Copy link
Copy Markdown
Contributor

This PR is a fix for issue #259

List of updates/fixes:

  • module xlsx renamed to excel.
  • Allow reading not only xlsx format but also xls, ods, xlsb
  • Allow Excel DateTime format and transform it to arrow Timestamp(Seconds, None)
  • Allow using NULLs in any data types and use null value instead of string "null"
  • Fix issue with incorrect data type inference when multiple data types are detected.
  • Add possibility to specify data schema in config.
  • Add new options: -
rows_range_start
  • rows_range_end
  • columns_range_start
  • columns_range_end
  • schema_inference_lines
  • Make sheet_name optional and if it is not specified than use first sheet by default

  • Bump calamine crate to version 0.23.1 and add feature "dates" (supporting for DateTime column format)

Documentation updates: roapi/docs#20

List of updates/fixes:
* Allow reading not only xlsx format but also xls, ods, xlsb
* Allow Excel DateTime format and transform it to arrow Timestamp(Seconds, None)
* Allow using NULLs in any data types and use null value instead of string "null"
* Fix issue with incorrect data type inference when multiple data types are detected.
* Add possibility to specify data schema in config.
* Add new options:
 -
rows_range_start
 - rows_range_end
 - columns_range_start
 - columns_range_end
 - schema_inference_lines
* Make sheet_name optional and if it is not specified than use first sheet by default

* Bump calamine crate to version 0.23.1 and add feature "dates" (supporting for DateTime column format)
@Maks-D

Maks-D commented Jan 7, 2024

Copy link
Copy Markdown
Contributor Author

Hi, @houqp 👋

I am finally started learning and coding in rust 🎉 and really appreciate your review of this PR.

@houqp
houqp merged commit 81a2520 into roapi:main Feb 1, 2024
@houqp

houqp commented Feb 1, 2024

Copy link
Copy Markdown
Member

Great to see you again @Maks-D ! Sorry that I have been really busy over the past 2 weeks and missed your PR :)

Your write very clean and easy to understand Rust code, great job.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants