DPlot Forum Index DPlot
http://www.dplot.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Macro *.csv import question

 
Post new topic   Reply to topic    DPlot Forum Index -> Suggestions/Questions
View previous topic :: View next topic  
Author Message
kdenney



Joined: 20 Nov 2014
Posts: 6

PostPosted: Wed Jan 21, 2015 3:30 pm    Post subject: Macro *.csv import question Reply with quote

Hello,

I looked briefly for a topic related to this but couldn't find anything.

I have written a macro to import a large quantity (1000s) of csv files in a single folder and generate plots and images, set scales, colors, etc. The *.grf and *.png files that are generated inherit the filename of the *.csv that is imported - this is great. Now to the question... Is there any way to link the Title of the chart to the csv filename as well? I've found when I generate a plot using the excel add-in, the title is inherited from either the filename and/or sheet name, but I can't seem to find any way to automatically set the title using the Title1("string") macro command.

Any help with this is greatly appreciated

Thanks in advance!
kd
Back to top
View user's profile Send private message
jsc



Joined: 02 Dec 2005
Posts: 222

PostPosted: Wed Jan 21, 2015 5:00 pm    Post subject: Reply with quote

I think the command in a macro is:

Title1("$FILETITLE")

Which should assign the filename to the first line of the title block area.
Back to top
View user's profile Send private message
kdenney



Joined: 20 Nov 2014
Posts: 6

PostPosted: Wed Jan 21, 2015 6:03 pm    Post subject: Reply with quote

jsc,

Thanks for the reply. Worked like a charm... Out of curiosity, it seems to be grabbing the "*.grf" in the title as well, do you know if this is editable?
Back to top
View user's profile Send private message
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2310
Location: Vicksburg, Mississippi

PostPosted: Wed Jan 21, 2015 7:17 pm    Post subject: Reply with quote

There is not, sorry.
_________________
Visualize Your Data
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
kdenney



Joined: 20 Nov 2014
Posts: 6

PostPosted: Thu Jan 22, 2015 8:44 am    Post subject: Reply with quote

Not a problem... Thanks!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    DPlot Forum Index -> Suggestions/Questions All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group