如何将Java HSSFSheet（POI API）传输到

发布于 2025-01-22 05:21:17 字数 589 浏览 0 评论 0原文

假设我们有1000000行学生的信息需要进入Excel，因为我无法非常清楚地拆分纸张，所以有人可以编写一个presudo代码来为我描述详细信息吗？数据可能会以下以下内容：例如[学生数字名称年龄地址] ...每行应该看起来像这样，并且行的最大长度为每张床单0-65535

我的答案可能会喜欢

每个数据例如（i＆lt; data）{

for(i < data) {
   //create a sheet
   // define the initial row
   // add data 
   // change row when finish
}
but there is a question when we have a page was full then how to make next data will consecutively connect to a new sheet ?
like we have running over 65535 data then we need to put 65536th data into next sheet first row and first column
am i make myself clear?

原文

assume we have 1000000 row of student info need to move into excel due to some indexout of bound problem that i cannot do split sheets very clear so can some one write a presudo code to describe the details for me please?
the data may like this following below:
e.g. [student-number name age address] ... each row should be look like this and with the maximum length of row which is 0-65535 per sheet

my answer may like

for loop each data
e.g. for(i < data) {

for(i < data) {
   //create a sheet
   // define the initial row
   // add data 
   // change row when finish
}
but there is a question when we have a page was full then how to make next data will consecutively connect to a new sheet ?
like we have running over 65535 data then we need to put 65536th data into next sheet first row and first column
am i make myself clear?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

吲‖鸣 2025-01-29 05:21:18

我的答案可能喜欢

循环每个数据
例如（i＆lt; data）{

for(i < data) {
   //create a sheet
   // define the initial row
   // add data 
   // change row when finish
}
but there is a question when we have a page was full then how to make next data will consecutively connect to a new sheet ?
like we have running over 65535 data then we need to put 65536th data into next sheet first row and first column
am i make myself clear?

my answer may like

for loop each data
e.g. for(i < data) {

for(i < data) {
   //create a sheet
   // define the initial row
   // add data 
   // change row when finish
}
but there is a question when we have a page was full then how to make next data will consecutively connect to a new sheet ?
like we have running over 65535 data then we need to put 65536th data into next sheet first row and first column
am i make myself clear?

回复收藏 0 原文

~没有更多了~