Are you having problems converting lines of text into rows of cells in a
Microsoft Excel worksheet because:
The text is arranged in columns, but is irregulary tabulated or paginated?
The text contains blank lines and/or blank pages?
The text contains more data than you actually want to import?
The text contains data that requires "de-normalizing"?
The worksheet has formats and formulae which must be preserved and adjusted?
The worksheet requires the insertion of formulae for "live" sub-totals.?
If you are spending too much time in Excel, editing the result of such text imports or
conversions, then L4X
may be the solution to your problems. L4X is an
"add-in" for Microsoft Excel
which allows "example" worksheets to be scripted in a little language
that controls exactly what
text is imported into Excel
L4X is designed to make the import of text from "legacy" reports
into Excel worksheets as easy and as fast as possible,
it can also import comma-separated values (CSV)
and other delimited values from a text-file.
Of course, you can always solve such problems using Visual Basic for Applications (VBA).
However, consider using L4X
is concise and easy to learn because it is designed specifically for
tasks of this nature. A script for most import problems will only be few lines long
and will be self explanatory because L4X is a "domain specific language".
The L4X editor/debugger (IDE) for
developing and running
an L4X script is much simpler than VBA, easy to use and is designed specifically for the task.
The L4X IDE has comprehensive and context-sensitive help,
The L4X IDE shows pages of text the text-file you are importing.
The L4X IDE has a "wizard" that help you create L4X statements,
that reflect the position of any selected text.
Once "scripted", worksheets can import text independently
Please click here to find out more about L4X
We pride ourselves on our prompt and responsive
of our products, and we value feedback from customers and visitors,
as it allows us to continually improve the reliability and functionality of L4X. .