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

[rcharan51]

1.) as you can see from the image mix(75,4) contains the values present in
D75 cell(02-01-3815) of input.xlsx  but mix(75,4) has

>> mix(75,4)
ans =
{
  [1,1] =  699442
}
I think this is a error related to xlsread.

2).  as you can see from the image particularly at C70 C74 and C76 all
these three cells from input.xlsx have bee read correctly into the mix cell
array  without any errors, mix(70, 3) is also read correctly.

>> mix(74,3)
ans =
{
  [1,1] = RAJ JUICE, NS MARG, DARIYAGANJ
}
>> mix(76,3)
ans =
{
  [1,1] =  JUNEJA AUTO PARTS, NS MARG, DARIYAGANJ
}

but the problem is when writing this mix array to  buildingcorrect
<http://octave.1599824.n4.nabble.com/file/n4665355/buildingcorrect.xlsx>.xlsx,
where nothing has been written into it( as you can see from right side of
Untitled.jpg
<http://octave.1599824.n4.nabble.com/file/n4665355/Untitled.jpg>  at C70
C74 and C76 )even though data is read into the mix cell array(as shown
above) with out  any errors .


On Fri, Jul 11, 2014 at 5:54 AM, Markus Bergholz [via Octave] <
address@hidden> wrote:

>
>
>
> On Wed, Jul 9, 2014 at 1:29 PM, rcharan51 <[hidden email]
> <http://user/SendEmail.jtp?type=node&node=4665405&i=0>> 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
>> [hidden email] <http://user/SendEmail.jtp?type=node&node=4665405&i=1>
>> https://lists.gnu.org/mailman/listinfo/help-octave
>>
>
>
>
> --
> icq: 167498924
> XMPP|Jabber: [hidden email]
> <http://user/SendEmail.jtp?type=node&node=4665405&i=2>
>
> _______________________________________________
> Help-octave mailing list
> [hidden email] <http://user/SendEmail.jtp?type=node&node=4665405&i=3>
> https://lists.gnu.org/mailman/listinfo/help-octave
>
>
> ------------------------------
>  If you reply to this email, your message will be added to the discussion
> below:
>
> http://octave.1599824.n4.nabble.com/Re-installing-java-and-apache-for-using-spreadsheet-I-O-tp4664767p4665405.html
>  To unsubscribe from Re: installing java and apache for using spreadsheet
> I/O, click here
> <http://octave.1599824.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4664767&code=c3JhMTBAaWl0YmJzLmFjLmlufDQ2NjQ3Njd8MTU5MDQyODc2Mw==>
> .
> NAML
> <http://octave.1599824.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>



-- 

Yours sincerely,

Raghu Charan A,
Third year undergraduate, School of Infrastructure,
Indian Institute of Technology (IIT) Bhubaneswar, India
Email: address@hidden ,address@hidden
Mobile No: +91 7205733924

-- 

------------------------------
*Disclaimer: *This email and any files transmitted with it are confidential 
and intended solely for the use of the individual or entity to whom they 
are addressed. If you have received this email in error please notify the 
system manager. This message contains confidential information and is 
intended only for the individual named. If you are not the named addressee 
you should not disseminate, distribute or copy this e-mail. Please notify 
the sender immediately by e-mail if you have received this e-mail by 
mistake and delete this e-mail from your system. If you are not the 
intended recipient you are notified that disclosing, copying, distributing 
or taking any action in reliance on the contents of this information is 
strictly prohibited.




--
View this message in context: 
http://octave.1599824.n4.nabble.com/Re-installing-java-and-apache-for-using-spreadsheet-I-O-tp4664767p4665438.html
Sent from the Octave - General mailing list archive at Nabble.com.