How can I use a relative path for Excel output?

Question

question

Craig DIckson asked Jun 27, '16 Logan Gold edited Jul 5, '16

How can I use a relative path for Excel output?

I am using Excel for both input and output from my model (which is completely process flow).

When I use MTEI to read in my input table, I am able to use a relative path, e.g. " ..\Data\Inputs.xlsx". But for MTEE and custom output, it seems to insist on the full path. Am I missing something? Thx

Software Version:

FlexSim 16.0.1

excel

Answer 1 · 2016-06-27T21:40:03Z

Adrian Haws answered Jun 27, '16 Logan Gold edited Jul 5, '16

Relative paths do work for MTEE, as long as the exporter is set up correctly. However, for custom export when you call

excelopen()

it needs the absolute path. If you want to use a relative path you can enter

excelopen(concat(modeldir(), “..\\Data\\Inputs.xlsx”))

Notice that there are two backslashes before and after “Data”.

· 5

Craig DIckson commented · Jun 27, 2016 at 11:03 PM

Taanks,

I'm not sure what I did before, but I did get the MTEE to use the relative path now. Is there a command I can call from code to run the MTEE at the end of run?

But I still am having problems with the custom export. When I run it I get a form that says:

"Could not open file c:\Projects\QVC\Solution\Model\..\Data\Outputs.xlsx". Seems like I may need another step to handle backing up a level? Note that the model is in:

c:\Projects\QVC\Solution\Model\*.fsm

while the Excel files are in

c:\Projects\QVC\Solution\Data\*.xlsx

Thanks,

Craig

0 ·

Adrian Haws Craig DIckson commented · Jun 28, 2016 at 09:20 PM

@Craig DIckson we've tested this in FlexSim 2016 with the ..\\ notation and it worked. When you export make sure it's to a file that has already been created, otherwise it won't work. Also, make sure to not have the spreadsheet open when you try to export to it.

0 ·

Craig DIckson Adrian Haws commented · Jun 28, 2016 at 10:10 PM

Adrian,

Can you look at this and see what's wrong (code below). It still doesn't seem to be working for me? I confirmed that the file and the sheet are both there.

excelopen(concat(modeldir(), "..\\Data\\Outputs.xlsx"));

// Set sheet to write to excelsetsheet("Orders");

// Write results

// Number of orders created excelwritenum(8,2,vOrderNumber);

excelexporttable("Output_Orders_OrderProfile",8,3,1,10);

excelclose(1);

0 ·

Show more comments

question