Re: installing java and apache for using spreadsheet I/O

[Markus Bergholz]

On Wed, Jul 9, 2014 at 1:29 PM, rcharan51 <address@hidden> wrote:

I replaced the file as you said .

xlsread is working good for the most of the part except at mix(75,4) which
has hyphens,

Can't follow you with mix(75,4)...

 

everything has been read into the mix cell array without any
mismatches.
>> mix(75,4)
ans =
{
  [1,1] =  699442
}
>> mix(74,3)
ans =
{
  [1,1] = RAJ JUICE, NS MARG, DARIYAGANJ
}
>> mix(76,3)
ans =
{
  [1,1] =  JUNEJA AUTO PARTS, NS MARG, DARIYAGANJ
}
inputcrctnbldg.m
<http://octave.1599824.n4.nabble.com/file/n4665355/inputcrctnbldg.m>

after writing the 'mix' cell array into 'buildingcorrect.xlsx'(which i
opened using libre office because i cant open using ms excel due to an
illegal character) I noticed that at so many locations no data has been
written into the output file(especially in the 3rd and 4th columns) like
shown in the below attached image even though  the data is present in the
mix cell array as shown above.

what should I do if I have to open the output file in excel.

Untitled.jpg
<http://octave.1599824.n4.nabble.com/file/n4665355/Untitled.jpg>


these are my input and output files
input.xlsx <http://octave.1599824.n4.nabble.com/file/n4665355/input.xlsx>
buildingcorrect.xlsx
<http://octave.1599824.n4.nabble.com/file/n4665355/buildingcorrect.xlsx>

I'll try to look into it on weekend, but I don't have MS Excel, so I can only test the output with Gnumeric e.g.

 

--
View this message in context: http://octave.1599824.n4.nabble.com/Re-installing-java-and-apache-for-using-spreadsheet-I-O-tp4664767p4665355.html

Sent from the Octave - General mailing list archive at Nabble.com.

_______________________________________________
Help-octave mailing list
address@hidden
https://lists.gnu.org/mailman/listinfo/help-octave

--
icq: 167498924
XMPP|Jabber: address@hidden