Export to Excel - empty Excel File

[growtharchitects]

Hi, i haven an issue, i’d like to export my generell overview - however when i’m exportin, i only get an empty excel (except the column descritions) - no data is exported.

If i try it in a different filtered view it works - howwwww?

Using Seatable on your servers.

Best
Bernhard

[rdb]

Can you send the base (or a shortened version) to support@seatable.io?

[The1Stormrider]

I now have the same Problem:

Hosting a Seatable - EE.

No tables in a Base have a Problem with exporting to Excel, except one. This file is normally downloading, but when opend, there is only the header in it.

With the other ones, it is working compleatly fine.

I tried allready to export to excel in another view and as another user. But all the same problem.

do you have any tipps

[rdb]

Can you check your log files for hints what may be wrong.

Are you on the latest SeaTable version?

[The1Stormrider]

I am on Version 3.3.7 EE
License is up to date

I may found an Error in dtable_events_io.log:

2023-02-01 14:01:34,697 [INFO] Run task: 1675256494696 <function convert_view_to_execl at 0x7f7eb2b01dd0>
2023-02-01 14:01:35,327 [ERROR] '>' not supported between instances of 'NoneType' and 'int'
Traceback (most recent call last):
  File "/opt/seatable/seatable-server-latest/dtable-events/dtable_events/dtable_io/excel.py", line 1334, in write_xls_with_type
    row_cells = handle_row(row, row_num, head, ws, grouped_row_num_map, email2nickname, unknown_user_set, unknown_cell_list)
  File "/opt/seatable/seatable-server-latest/dtable-events/dtable_events/dtable_io/excel.py", line 1284, in handle_row
    formula_value, number_format = parse_formula_number(row[col_num], head[col_num][2])
  File "/opt/seatable/seatable-server-latest/dtable-events/dtable_events/dtable_io/excel.py", line 1075, in parse_formula_number
    value = convert_formula_number(value, column_data)
  File "/opt/seatable/seatable-server-latest/dtable-events/dtable_events/dtable_io/excel.py", line 992, in convert_formula_number
    if precision > 0 or decimal == 'dot':
TypeError: '>' not supported between instances of 'NoneType' and 'int'
2023-02-01 14:01:35,328 [ERROR] Error row in exporting excel: '>' not supported between instances of 'NoneType' and 'int'
2023-02-01 14:01:35,361 [INFO] Run task success: 1675256494696 <function convert_view_to_execl at 0x7f7eb2b01dd0> cost 0s

Again in the dtable-events.log:

[2023-02-01 14:03:43,028] task_manager.py[line:335] [INFO] Run task: 1675256623027 <function convert_view_to_execl at 0x7f7eb2b01dd0>
[2023-02-01 14:03:43,781] excel.py[line:1337] [ERROR] '>' not supported between instances of 'NoneType' and 'int'
Traceback (most recent call last):
  File "/opt/seatable/seatable-server-latest/dtable-events/dtable_events/dtable_io/excel.py", line 1334, in write_xls_with_type
    row_cells = handle_row(row, row_num, head, ws, grouped_row_num_map, email2nickname, unknown_user_set, unknown_cell_list)
  File "/opt/seatable/seatable-server-latest/dtable-events/dtable_events/dtable_io/excel.py", line 1284, in handle_row
    formula_value, number_format = parse_formula_number(row[col_num], head[col_num][2])
  File "/opt/seatable/seatable-server-latest/dtable-events/dtable_events/dtable_io/excel.py", line 1075, in parse_formula_number
    value = convert_formula_number(value, column_data)
  File "/opt/seatable/seatable-server-latest/dtable-events/dtable_events/dtable_io/excel.py", line 992, in convert_formula_number
    if precision > 0 or decimal == 'dot':
TypeError: '>' not supported between instances of 'NoneType' and 'int'
[2023-02-01 14:03:43,782] excel.py[line:1338] [ERROR] Error row in exporting excel: '>' not supported between instances of 'NoneType' and 'int'
[2023-02-01 14:03:43,812] task_manager.py[line:343] [INFO] Run task success: 1675256623027 <function convert_view_to_execl at 0x7f7eb2b01dd0> cost 0s

Any Ideas?

[rdb]

For all your number columns, remove the precision settings and use dot as decimal separator.

Then try again.

If it does not work, do the same for formula and link formula columns.

Try again.

If it still does not work, hide all your formula and link formula columns.

Then export the view (hence without formula and link formula columns).

After this exercise, we should know what causes the export to not run properly.

[The1Stormrider]

After i hide all of my formula and link formula columns. It worked, even with commas at normal Number Columns.

Here are the formulas:

[rdb]

@Leo.Shi Could you have a look at it?

[Leo.Shi]

Sorry, I did the test and didn’t repeat this problem

[The1Stormrider]

@Leo.Shi Is there a way, how we could have a look at it together?

[rdb]

Could you export the base and send to support@seatable.io? If it contains sensitive information, remove the respective columns before exporting.

[The1Stormrider]

I could. But. After copying the base, and switching all Formulas again to Points it now works.

Same for commas.
I can’t send you the original, because i do not have the rights (not my base).

So the solution is:
Every number in a function should have the same decimal-settings and probably same “thousends”-Settings?

[rdb]

I just successfully exported this to Excel:

But I hear that your problem has been solved?

[The1Stormrider]

Yes, the Problem could be solved, by setting the conf of all Numbers to “,”

Thank you!