RE: XLSWrite

[Philip Nienhuis]

Allen.Windhorn-2 wrote:
> 
> -----Original Message-----
> From: Philip Nienhuis [mailto:address@hidden 
>>> Creating file c:/test2.xls
>>> Supported interfaces:  Excel (COM) OK. warning: split is obsolete
>>> and will be removed from a future version of Octave.  Use strsplit
>>> instead
>>> Java/Apache (POI) OK. (& OOXML OK)   Java/JExcelAPI (JXL) OK.
> 
>> ...The write error might be related to the forward slash in the
>> file name (you're running octave under windows, don't you?)
>> ...
>> Under windows you should use backslashes when accessing files
>> (Excel.exe, which is magically invoked behind the scenes, wouldn't
>> know what to do with forward slashes)...
> 
> Apparently you have to use DOUBLE backslashes (to keep them from
> being interpreted by Octave?)  But forward slashes work fine for me.
> 

Watch this.... (Octave-MingW 3.2.4 with development versions of scripts):
octave-3.2.4.exe:1> cd spreadsheet-tst
octave-3.2.4.exe:2> dir *.xls
Copy of formtst.xls  data1.xls            test116.xls          testjava2.xls
Empty1.xls           formtst.xls          test34.xls           tst2.xls
Octave_test.xls      javaworkbook.xls     test75.xls           xslxtest.xls
bakje_MP1_TO.xls     test100.xls          testa.xls
booltst.xls          test1000.xls         testjava.xls
octave-3.2.4.exe:3> cd ..
octave-3.2.4.exe:4> xlsfinfo ('spreadsheet-tst\\testa.xls')
Supported interfaces: Excel (COM) OK. Java/Apache (POI) OK. Java/JExcelAPI
(JXL) OK.
  1: Sheet10                          (Used range ~ A1:C3)
  2: Sheet10_                         Empty
  3: Sheet10__                        (Used range ~ A1:C3)
  4: Sheet10___                       (Used range ~ A1:D3)
  5: Sheet10____                      (Used range ~ A1:D3)
ans = Microsoft Excel Spreadsheet
octave-3.2.4.exe:5> xlsfinfo ('spreadsheet-tst\testa.xls')
  1: Sheet10                          (Used range ~ A1:C3)
  2: Sheet10_                         Empty
  3: Sheet10__                        (Used range ~ A1:C3)
  4: Sheet10___                       (Used range ~ A1:D3)
  5: Sheet10____                      (Used range ~ A1:D3)
ans = Microsoft Excel Spreadsheet
octave-3.2.4.exe:6> xlsfinfo ('spreadsheet-tst/testa.xls')
  1: Sheet10                          (Used range ~ A1:C3)
  2: Sheet10_                         Empty
  3: Sheet10__                        (Used range ~ A1:C3)
  4: Sheet10___                       (Used range ~ A1:D3)
  5: Sheet10____                      (Used range ~ A1:D3)
ans = Microsoft Excel Spreadsheet
octave-3.2.4.exe:7> xlsfinfo ('spreadsheet-tst//testa.xls')
  1: Sheet10                          (Used range ~ A1:C3)
  2: Sheet10_                         Empty
  3: Sheet10__                        (Used range ~ A1:C3)
  4: Sheet10___                       (Used range ~ A1:D3)
  5: Sheet10____                      (Used range ~ A1:D3)
ans = Microsoft Excel Spreadsheet
octave-3.2.4.exe:8> xlsfinfo ('spreadsheet-tst/////testa.xls')
  1: Sheet10                          (Used range ~ A1:C3)
  2: Sheet10_                         Empty
  3: Sheet10__                        (Used range ~ A1:C3)
  4: Sheet10___                       (Used range ~ A1:D3)
  5: Sheet10____                      (Used range ~ A1:D3)
ans = Microsoft Excel Spreadsheet
octave-3.2.4.exe:9> xlsfinfo ('spreadsheet-tst\\\\\testa.xls')
  1: Sheet10                          (Used range ~ A1:C3)
  2: Sheet10_                         Empty
  3: Sheet10__                        (Used range ~ A1:C3)
  4: Sheet10___                       (Used range ~ A1:D3)
  5: Sheet10____                      (Used range ~ A1:D3)
ans = Microsoft Excel Spreadsheet
octave-3.2.4.exe:10> xlsfinfo ('spreadsheet-tst\\\\\testa.xls', 'poi')
Java/Apache POI interface requested... Java/Apache (POI) OK.
  1: Sheet10                          (Used range ~ A1:C3)
  2: Sheet10_                         Empty
  3: Sheet10__                        (Used range ~ A1:C3)
  4: Sheet10___                       (Used range ~ A1:D3)
  5: Sheet10____                      (Used range ~ A1:D3)
ans = Microsoft Excel Spreadsheet
octave-3.2.4.exe:11> xlsfinfo ('spreadsheet-tst/////testa.xls', 'poi')
Java/Apache POI interface requested... Java/Apache (POI) OK.
  1: Sheet10                          (Used range ~ A1:C3)
  2: Sheet10_                         Empty
  3: Sheet10__                        (Used range ~ A1:C3)
  4: Sheet10___                       (Used range ~ A1:D3)
  5: Sheet10____                      (Used range ~ A1:D3)
ans = Microsoft Excel Spreadsheet
octave-3.2.4.exe:12> 

Forward or backward, in any amount, doesn't seem to matter....

BTW please reply to list only, not to my private e-mail address.

Philip
-- 
View this message in context: 
http://octave.1599824.n4.nabble.com/XLSWrite-tp2993033p2994435.html
Sent from the Octave - General mailing list archive at Nabble.com.