question

Anna LeBlanc avatar image
0 Likes"
Anna LeBlanc asked Jeanette F commented

Clear an excel cell range before export

I have try to follow the steps of a query posted some months ago on the forum, however, I haven't been able to get it. My goal is to delete a range of the excel sheet before exporting the data. In the following image can be seen what I want to delete:1713539865313.png

I have try to make it using the Custom Export on FlexSim but I haven't succeeded. Please can anybody help me with the code for making this possible? For making easier the answer I have upload a sample file with the model and the excel file.

test.fsm

exporting.xlsx

FlexSim 23.1.0
exportexcelclear excel
1713539865313.png (208.4 KiB)
test.fsm (67.1 KiB)
exporting.xlsx (11.6 KiB)
· 2
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Anna LeBlanc avatar image Anna LeBlanc commented ·
Could please anybody help me? I still don't know how to clear a range of the excel before exporting.
0 Likes 0 ·
Jeanette F avatar image Jeanette F ♦♦ commented ·

Hi @Anna LeBlanc,

Thank you for contributing to our community! We couldn't identify a maintained license or subscription linked to your account.

You may need to update your profile information to identify yourself as a license owner or their associate. Check out our article for how to ensure you receive timely support. If you update your profile comment back to let us know - we'll adjust the priority of your post accordingly.

0 Likes 0 ·

1 Answer

·
Joerg Vogel avatar image
0 Likes"
Joerg Vogel answered Anna LeBlanc commented

You can do a table query over your currently available data. In section of select you parse column names you want to keep and order. The result will be a new temporary table. This can you cloneTo another global table for export.

· 1
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Anna LeBlanc avatar image Anna LeBlanc commented ·

Perhaps I haven't explain myself well. What I want is to clear a range of the excel sheet for importing the data of the dahsboards there. So, I need to clear a range before exporting the dashboards of FlexSim.

The following link contains something similar of what I want to get: https://answers.flexsim.com/questions/139796/clear-excel-before-export.html

I have try many different solutions and I'm not able of getting it. I would be very grateful if somebody help me with this.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.