User Forum
Xequte User Forums
Profile    Active Topics    Forum FAQ    Search this forumSearch
Forum membership is Free!  Click Join to sign-up
Username:
Password:
Save Password
Forgot your Password?

     
Forum Tips
» This forum is for users to discuss their software problems and suggestions for improvement.  Remember that only a tiny percentage of our users experience such problems (To be precise less than 0.7% have ever posted on this forum)
» Include your software version number (as displayed in the About Box)
» Check the FAQ before posting as most common questions have already been answered
» You don't need to also e-mail us separately as our support team will respond to all questions on this forum
 
 All Forums
 Xequte User Forums
 Other Software and Discussion
 Import Text Lightning from Excel
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dougransom

Canada
44 Posts

Posted - Jul 14 2017 :  12:17:01  Show Profile  Reply
1. I frequently need to import a triple from excel database (fund code, description, commission, attachment name) into a text lightning that will produce output like

fund code description
disclosure: $25 ticket charge. Commission paid by issuer: commission. Product details attached.

Is there a way in text lightning to use an existing quick text and to just fill in the blanks from the import step?

2. For future release request support for macro-enabled spreadsheets (xlsm).


doug ransom

xequte

7504 Posts

Posted - Jul 16 2017 :  00:56:20  Show Profile  Reply
Hi Doug

1. You can import the data on the fly from an ini file, e.g.

%ADVANCED_READ_FROM_INI_FILE:C:\MYPRODUCT.INI[MAIN]FUNDCODE%

Where MYPRODUCT.INI is a text file formatted like:

[MAIN]
FUNDCODE=12345
FUNDDESC=My description

2. We'll consider that in the future


Nigel
Xequte Software
www.xequte.com
nigel@xequte.com

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To: