Skip to content

Conversation

Maks-D
Copy link
Contributor

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

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
Copy link
Contributor Author

Maks-D commented Jan 7, 2024

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
Copy link
Member

houqp commented Feb 1, 2024

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