Comments (3)
I am using this spring-batch-excel in our application, It is automatically converting the number fields with .0 to make it as number. Could you please let me know how to disable this auto conversion and let the RowMapper returns always string for all cloumns.
from spring-batch-extensions.
If you've built spring-batch-excel
from my pull request, have a look at the test cases to see how to still get String
for all columns.
from spring-batch-extensions.
The issue is that when using a streaming result the result is always a formatted cell value as a String
. What would be the better solution is to make methods on the RowSet
to get the value of a row as a specific type. Just like the SQL based SqlRowSet
which has getLong
, getDate
for specific columns. That way you can get the specified result from the RowSet
to use in the RowMapper
.
For a classis PoiSheet
we could use the underlying sheet/row to get the values (as you can get the value as is from the cell) for the StreamingSheet
we would need to convert the String
back to the specific type, for this we could use the Spring Framework ConversionService
?
from spring-batch-extensions.
Related Issues (20)
- Upgrade maven-compiler-plugin to 3.10.1
- Upgrade surefire/failsafe to version 3.0.0-M7
- Upgrade checkstyle plugin to 3.2.0
- Upgrade Maven Javadoc Plugin to 3.4.1
- Downgrade Checkstyle to version 9.3
- Upgrade to Spring Batch 5 HOT 5
- Multithread with specific chunk size the reader distributes duplicates records across threads HOT 2
- startStatement() should not be required in Neo4jItemReader HOT 1
- Read columns as arrays HOT 4
- getColumnNames(Sheet sheet) → UnsupportedOperationException: Getting row by index not supported when streaming. HOT 1
- IsoFormattingDateDataFormatter does not work HOT 4
- DefaultRowset method getColumnValue is Missing HOT 1
- Date format when reading HOT 3
- Issue with spring-batch-excel using Resource which might not have getFile() implemented and does not throw a FileNotFoundException exception HOT 4
- Publish Spring Batch Excel 0.1.1 artifacts to maven HOT 3
- Upgrade to Spring Batch 4.3.5
- Need of reading one particular sheet. HOT 3
- AbstractExcelItemReader ignores a number of empty rows inbetween filled set of rows.It would help if the this functioning is made configurable since this causes incorrect meta data provided for the row number. HOT 2
- Not able to open excel files larger than 10MB HOT 6
- When extracting data from the RowSet (rs) year in date cell is shortened HOT 20
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from spring-batch-extensions.