Hello:
I have a currently existing Excel 2007 sheet that I can do a (In
Excel) Refresh All for \\APOLLO\e\WeatherLink\JACW3\download.txt which
is a test file in the format of:
Temp Hi Low Out Wind Wind Hi
Hi Wind Heat THSW Rain Solar Solar Hi
Solar UV Hi Heat Cool In In In In In
In Air Soil 1 Soil Leaf Wind Wind ISS Arc.
Date Time Out Temp Temp Hum Dew Speed Dir Run
Speed Dir Chill Index THW Index Bar Rain Rate Rad.
Energy Rad. UV Dose UV D-D D-D Temp Hum Dew
Heat EMC Density ET Moist. Temp 1 Wet 1 Samp Tx Recept
Int.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7/22/11 0:01 75.6 75.6 75.6 69 64.7 1.0 WNW 0.02
1.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00
0 0.0 0.00 0.0 0.000 0.007 79.5 46 56.9 79.3 8.46
.0722 0.000 153 69.0 15 9 1 39.1 1
7/22/11 0:02 75.6 75.6 75.6 69 64.7 2.0 WNW 0.03
3.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00
0 0.0 0.00 0.0 0.000 0.007 79.5 47 57.5 79.3 8.66
.0722 0.000 153 69.0 15 20 1 87.0 1
7/22/11 0:03 75.6 75.6 75.6 69 64.7 1.0 WNW 0.02
2.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00
0 0.0 0.00 0.0 0.000 0.007 79.5 47 57.5 79.3 8.66
.0722 0.000 153 69.0 15 22 1 95.7 1
7/22/11 0:04 75.6 75.6 75.6 69 64.7 1.0 WNW 0.02
3.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00
0 0.0 0.00 0.0 0.000 0.007 79.5 48 58.1 79.4 8.86
.0721 0.000 153 69.0 15 21 1 91.3 1
7/22/11 0:05 75.6 75.6 75.6 69 64.7 1.0 WNW 0.02
3.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00
0 0.0 0.00 0.0 0.000 0.007 79.5 48 58.1 79.4 8.86
.0721 0.000 153 69.0 15 21 1 91.3 1
and is properly formatted automatically by a Text-To Colums 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 (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 jut
come in to be used by 15 past the next hour.
Can anyone help with this? As of right now its the one thing keeping
me from dumping the Office 2007 suite.
--
===[George R. Kasica]=== +1 262 677 0766
President +1 206 374 6482 FAX
Netwrx Consulting Inc. Jackson, WI USA
http://www.netwrx1.com
georgek@netwrx1.com
ICQ #12862186
--
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