|
From: | Markus Bergholz |
Subject: | Re: installing java and apache for using spreadsheet I/O |
Date: | Sat, 12 Jul 2014 10:52:12 +0200 |
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
I think this is a error related to xlsread.
>> mix(75,4)
ans =
{
[1,1] = 699442
}
address@hidden:~/tmp/xl$ grep -r "02-01-3815" * address@hidden:~/tmp/xl$
There is no "02-01-3815" reference in input.xlsx
And in sheet1.xml cell D75 (75,4) the value is 699442
<c r="D75" s="15"> <v>699442</v> </c>
octave:3> datestr (699442) ans = 03-Jan-1915
octave:15> datenum ('01-01-1900','dd-mm-yyyy') ans = 693962 octave:16> datestr(699442 + 693962,'dd-mm-yyyy') ans = 04-01-3815 octave:17> datestr(699442 + 693961,'dd-mm-yyyy') ans = 03-01-3815 octave:18> datestr(699442 + 693960,'dd-mm-yyyy') ans = 02-01-3815
so xlsread is fine.
and xlswrite...I try to look later.
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.
but the problem is when writing this mix array to buildingcorrect
>> mix(74,3)
ans =
{
[1,1] = RAJ JUICE, NS MARG, DARIYAGANJ
}
>> mix(76,3)
ans =
{
[1,1] = JUNEJA AUTO PARTS, NS MARG, DARIYAGANJ
}
<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:
>> [hidden email] <http://user/SendEmail.jtp?type=node&node=4665405&i=1>
>
>
>
> 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
> 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
>> http://octave.1599824.n4.nabble.com/Re-installing-java-and-apache-for-using-spreadsheet-I-O-tp4664767p4665405.html
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
>
> 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.
_______________________________________________
Help-octave mailing list
address@hidden
https://lists.gnu.org/mailman/listinfo/help-octave
[Prev in Thread] | Current Thread | [Next in Thread] |