
|
If you were logged in you would be able to see more operations.
|
|
|
The attached patch adds the possibility to set a table name that is different from the sheet name. I suppose there are better ways to set an association between table and excel sheet but this seems to be the most compatible.
There are some scenarios where this may be needed:
- Different hibernate objects that are mapped to the same table. It's nice to keep each object data in a different sheet but have tha table populated correctly.
- Data that should be inserted in a table is more that one single excel sheet can handle. Excel has a limit of 65535 lines per sheet, so there may be the need to split the data for a single table in more than one sheet.
- Table name could contain characters that Excel doesn't handle. It's a good practice to keep table names in uppercase alpha, but you never know what a user wuold really do...
|
|
Description
|
The attached patch adds the possibility to set a table name that is different from the sheet name. I suppose there are better ways to set an association between table and excel sheet but this seems to be the most compatible.
There are some scenarios where this may be needed:
- Different hibernate objects that are mapped to the same table. It's nice to keep each object data in a different sheet but have tha table populated correctly.
- Data that should be inserted in a table is more that one single excel sheet can handle. Excel has a limit of 65535 lines per sheet, so there may be the need to split the data for a single table in more than one sheet.
- Table name could contain characters that Excel doesn't handle. It's a good practice to keep table names in uppercase alpha, but you never know what a user wuold really do...
|
Show » |
Sort Order:
|
I already committed the patch, you can close the issue if you accept the improvement.