repost of a problem with ImportSpreadsheet 
Author Message
 repost of a problem with ImportSpreadsheet

I'm reposting this 'cause no one commented on this.
Any ideas, anyone?

>Hello, all,
>The Paradox for Windows 5.0 reference manual says:
>   --------------------------------------------------------------
>    importSpreadsheet(const fileName String,
>                      const tableName String,
>                      const fromCell String,
>                      const toCell String
>                      [, const getFieldNames Logical])

>    Using this procedure, you can write ObjectPAL code to duplicate
>    the functionality of the Spreadsheet Import dialog box.
>    ---------------------------------------------------------------
>I've been trying to use it and have had some problems.
>    1. The dialog box supplies default values for fromCell and
>       toCell which cover the spreadsheet.  The method requires
>       a range but I see no way of finding the range in code.
>    2. The dialog box doesn't require that tableName already
>       exist but the method does.  In my case, that doesn't
>       matter but for a more flexible application, it would
>       be more than a nuisance.
>    3. I looked at the spreadsheet (with QPro 5.0) and found the
>       range and I created the table.  Then I ran
>       importSpreadsheet() without error but tableName has 0
>       records.  I supplied only the source and destination to
>       the dialog box and tableName was created just fine.

>I contend that importSpreadsheet() does not "duplicate the
>functionality..." but would love to hear that I've missed something.

Pdoxwin.exe is dated August 5, 1994.  Does anyone know if
there have been any revisions since then?


University of Colorado       Denver, CO

Tue, 03 Jun 1997 19:52:52 GMT
 [ 1 post ] 

 Relevant Pages 

1. importSpreadsheet problem

2. importSpreadsheet problem

3. problem with importSpreadsheet()

4. importSpreadsheet

5. Bug in importSpreadsheet?????

6. P4W importSpreadSheet()

7. REPOST: [OT] "REPOST"s ????

8. ADO - Interval - REPOST REPOST.......

9. Repost: Update problems

10. REPOST:Replication to Sybase problem


12. Repost: Two problems: SUMming into a new row, and dynamic

Powered by phpBB® Forum Software