Xequte User Forums - Import Text Lightning from Excel

Xequte User Forums

Profile Active Topics Forum FAQ

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

Topic

dougransom

Canada
44 Posts

Posted - Jul 14 2017 : 12:17:01

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

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

Topic

New Topic

Reply to Topic

Printer Friendly