Excel export error?

Question

question

gilbert jerald asked Feb 21 2018 at 5:47 AM gilbert jerald commented Mar 12 2018 at 10:57 AM

Excel export error?

Hi

The key thing which i am expecting is. How to export the output results into excel without clearing the previous exported results in the same excel sheet.

The problem here is when i try to export the new results, the old exported results remains unchanged. so this problem let me to create a new excel every time when i try to export different results. Is there any way to overcome this problem. Your answer is very much useful.

Thank you.

Software Version:

FlexSim 18.0.1

excel export

· 2

Jeff Nordgren commented · Mar 02 2018 at 11:35 PM

@gilbert jerald

Could you send us your model and a description of exactly how you are now trying to do it? Are you doing several manual runs of the model? Are you using the Experimenter? It would help to understand how you are trying to do this and what you need to end up with. A model would certainly help.

Thanks.

0 ·

gilbert jerald Jeff Nordgren commented · Mar 07 2018 at 2:32 AM

@ Jeff Nordgren

Thanks for your reply. I have attached the sample model for your better understanding of my problem.

I have attached two models

1) Excel Sample Model_1

2) Excel Sample Model_2

In this, the first model global table consists of 4 rows 5 columns and this table consist of value that needs to be exported to excel (Book_1) sheet1

In the second model global table consists of 3 rows 4 columns and this table consist of some value that needs to be exported into the same excel (Book_1) sheet1

The problem which I am facing is when I export the first model global table values (4 rows 5 columns) into an empty excel (Book_1) Sheet1. The excel print the value associated with the first model global table (4 rows 5 columns)

and now when I try to export the second model global table values (3 rows 4 columns) into same the same excel (Book_1)Sheet1. The excel print the value associated with the second model global table but the previously exported data in excel 4th row 5th column values are not getting deleted.I want only the value associated with the second model to be printed. How to over come this problem.

The bellow pic will explain the above statement

2)

Below i have attached the model for your reference have a look at it.

excel-sample-model-1.fsm excel-sample-model-2.fsm book1.zip

Thank you.

0 ·

excel-sample-model-1.fsm (41.4 KiB)

excel-sample-model-2.fsm (41.4 KiB)

book1.zip (5.6 KiB)

model-1.png (91.9 KiB)

model-excel-1.png (84.9 KiB)

model-2.png (92.8 KiB)

model-excel-2.png (84.1 KiB)

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Answer 1 · 2018-03-07T02:49:04Z

Matt Long answered Mar 07 2018 at 2:49 AM gilbert jerald commented Mar 12 2018 at 10:57 AM

All you need to do is make your second table 4 x 5 with the 4th row and 5th column being empty. This will ensure that those cells are cleared when you do the second export. Use string data in those empty cells so they don't export 0's into your excel sheet.

· 3

gilbert jerald commented · Mar 12 2018 at 9:13 AM

@ Matt Long

Hi,

Thanks for your reply. I understand your answer. But the model which I have attached you is just a sample model, in my original model, the model doesn't know how many rows will be generated. only at the end of the model only we can know how many rows have been generated.Because I have used Add row to the global table command, So in my case, I don't know how many rows this command is going to write on the global table.

Thank You

0 ·

Joerg Vogel gilbert jerald commented · Mar 12 2018 at 9:30 AM

You know the number of rows and columns you updated the time before. You use this data to clear the table and update the values. On Reset you open an empty excel file that you rename in the system.

0 ·

gilbert jerald Joerg Vogel commented · Mar 12 2018 at 10:57 AM

I have tested your idea but I can achieve this by manually clearing the data where else I need the data in excel to be cleared through code from flexsim model is there any way to help me.

0 ·

question