×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Where does the spreadsheet reside? In the iSeries' IFS or on some other
server?
Also, how are you trying to refresh the data? While in Excel or are you
just wanting to replace the contents of the file?
Gary Monnier
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Willie J. Moore
Sent: Tuesday, February 08, 2011 1:08 PM
To: 'rpg400-l@xxxxxxxxxxxx'
Subject: Iseries file to an Excel spreadsheet
I have posted this on the Midrange-L site with no response. I thought I
would try here and see if I have better luck.
I have a file on the iseries and an Excel spreadsheet.
Spreadsheet name=open percentages.xa.2011, worksheet name=wek%2003.
I want to copy the iseries file into the spreadsheet, replacing the
data in the worksheet. I have a 'DCL' with the spreadsheets name. I am
having trouble replacing the spreadsheet data with the file data.
File layout: date, total orders, total items, prod due & prod due %.
Excel spreadsheet: date, total orders, total items, prod due & prod due
%.
Any help would be greatly appreciated.
Thank you,
William Moore
California Fine Wire
805-489-5144
wjmoore@xxxxxxxxxxxx
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
