Export values to an Excel file

damienbusca

Hi everyone,

I would like to know how it is possible to import values (strain, stress) to an Excel file. I already manage to get them in the .resu file but I would like to fast export them to Excel to plot curves (I really need to use Excel for it).

Is there an easy way to do that?

Thanks a lot

Damien

damienbusca

at least I would like to export them to a file where I could easily copy/paste them to Excel (all the values at once), which I don't manage to do with the .resu file.

jeanpierreaubry

hello

this is easy,

read the doc for IMPR_TABLE, U4.91.03

before that you have to create the table POST_ELEM and POST_RELEVE_T do the job

jean pierre aubry

damienbusca

hello,

I still don't get the exact way to do that. I first created a table with POST_RELEVE_T, and I printed it with IMPR_TABLE.

Which format do I have to choose and in which kind of file do I have to print it? I chose 'TABLEAU' so it's printed inside of the .resu file.

jeanpierreaubry

this abstract does it

#calculate the sum of the reaction in a table


sum_reac=POST_RELEVE_T(ACTION=_F(INTITULE='somme_reactions',
	GROUP_NO=('apppot','appmt',),RESULTAT=statnl,NOM_CHAM='REAC_NODA',
	LIST_INST=listr,
	RESULTANTE=('DX','DY','DZ',),OPERATION='EXTRACTION',),);
#print the table in the .resu file
IMPR_TABLE (TABLE=sum_reac,)
#print the table in the  file declared (in ASTK) with LU=9 with the format of a tableau

IMPR_TABLE (TABLE=sum_reac, UNITE=9, FORMAT='TABLEAU',INFO=1,)

damienbusca

Ok this is getting clearer.

My last question is: which type of file do I have to create in astk?

Thanks a lot

jeanpierreaubry

just "resu"

this means ASCII file

you probably have to play a biçt wit SEPARATEUR to get what you want

damienbusca

Sorry to disturb again but I don't find a way to get the compatibility between windows and linux.

I'm using ASTER with linux.

I imported the .erre (9LU) file to windows but I can't read it. And the copy/paste function doesn't work from linux to windows.

How can I transfer data from this file to Excel?

RichardS

Hello Damien,

I normally use .dat format to print tables and never had problems with windows/linux.

Regards,

Richard

damienbusca

Hello Richard

Thanks a lot for your answer.

I managed to import and to open the.dat file with windows, but I still can't transfer the values to Excel. I'm probably doing something wrong.

I tried those things:

- Open the .dat file with notepad++

- Open the file directly into Excel

In the first case I get the table but I can't copy/paste the values, they are printed into excel as chains of characters, not as values.

Same problem in the second case.

Regards

RichardS

Hello Damien,

if you see the correct numbers in the .dat file this is not a linux problem.

If you import the table to excel you probably have to set the correct import options.

You can use the text-import assistant (if u copy and paste the numbers you see the symbol on right lower end of the imported columns) and set the proper decimal separator and so on.

Regards,

Richard

Ps: Use PSPad instead of notepad.

damienbusca

I finally solved my problem.

Thanks a lot for your advices :-)

Best regards

Damien