At 07:48 23/07/2011 -0500, George R. Kasica wrote:
I have a currently existing Excel 2007 sheet that I can do a (In
Excel) Refresh All for \\APOLLO\e\WeatherLink\JACW3\download.txt ...
So that's a file available to your system?
... which is a te[x]t file in the format of: [...] and is properly
formatted automatically by a Text-To-Columns setup already in the MS
Excel sheet so all I need to do each day is Refresh All and select
the filename and it pulls in the data in the proper column.
For the life of me I cannot see how to do this in Calc...and opening
the existing sheet gets the right format, but I'm at a loss of how
to get new data into it without redoing the whole text to columns
every time ...
Try this:
o Go to Insert | Sheet From File..., browse to your .txt file, and
click Insert.
o In the Text Import dialogue, under "Separator options", select
"Separated by", "Space", and "Merge delimiters".
o Click OK.
o In the Insert Sheet dialogue, select the position of your new
sheet and - crucially - tick Link.
o Click OK.
Each time you open this spreadsheet, you will have the option to
update this new sheet; alternatively, you can go to Edit | Links...
and click Update. Note that, since the entire sheet is updated, any
calculations you perform on that sheet will be lost - so you will
have to move your calculations to other sheets.
If this data is downloaded from the web, you may prefer instead to
use Insert | Link to External Data... and import directly from the web page.
... (not an option due to time constraints here each day when this
has to happen...data is available at 59 past the hour and needs to
just come in to be used by 15 past the next hour.
You can do a lot in sixteen minutes!
I trust this helps.
Brian Barker
--
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.