FIlling excel sheet from array problem
FIlling excel sheet from array problem
FIlling excel sheet from array problem
FIlling excel sheet from array problem
FIlling excel sheet from array problem
FIlling excel sheet from array problem FIlling excel sheet from array problem FIlling excel sheet from array problem FIlling excel sheet from array problem FIlling excel sheet from array problem FIlling excel sheet from array problem FIlling excel sheet from array problem FIlling excel sheet from array problem
FIlling excel sheet from array problem FIlling excel sheet from array problem
FIlling excel sheet from array problem
Go Back  Xtreme Visual Basic Talk > > > FIlling excel sheet from array problem


Reply
 
Thread Tools Display Modes
  #1  
Old 11-02-2012, 02:47 AM
nighttrain nighttrain is offline
Newcomer
 
Join Date: May 2012
Posts: 1
Default FIlling excel sheet from array problem


Hello all,

i got problem i am using excel 2003 and vb.net 2005. I am trying to fillthe excell shet by data from array (before that i am filling up the array from database). Anyyway, after filled an array and then fill excel sheet its stopping on some rows with error:
Code:
System.Runtime.InteropServices.COMException <0x800A03EC>: Exception from HRESULT: 0x800A03EC
heres my code, check for DataArray(0,1) value its generating error for this row for example.
Code:
DataArray(0, 0) = "4533-440"

'THIS BELOW !!!!

 DataArray(0, 1) = " ' please check if the frtyk below are okokok to the JKK 433333" & _
"44444     *                                         Palern West        " & _
                            "gkgkgkgkg(Ghdyuwiq) " & _
                            "DDMN(-DDMN / TDXX - 1 / THHH - 25001) " & _
                            "Einhjal(DEGRADE) " & _
"Ttttttt    2010-09-27 22:47:49                                               " & _
"Myyyy ID   4886150                   " & _
"Suppl Info Interface Unit 1-B/U5/VC12 SO M1/IF1 2-5-1 SPT:12 Ttttttt degrade NID:  " & _
"25001:                          NNM() : Dddd(-T60 - 5) " & _
"Diag Info  Probable cause: 0  " & _
"Object     Tttttttww                              COMMUNICATION       " & _
"dddd NE    Tttttttww            Crissier          Palern West              " & _
"" & _
"36066     *                                         Palern Ffff         " & _
                            "FG5655(-1) " & _
                            "DDMN(-PLMN / HJJX - 1 / TNOD - 3) " & _
                            "MISSING(UNIT) " & _
"Ttttttt    2010-09-28 01:01:08                                               " & _
"Myyyy ID   4889177                   " & _
"Suppl Info Control Unit 1-B/U14/Unit Inventory U10 SPT:262147 Missing unit NID:3  " & _
"NNM:                            ZH9900_T60(-1) " & _
"Diag Info  Probable cause: 0  " & _
"Rrrrrr     ZH9900_T60-0001                        EQUIPMENT           " & _
"Ctrl JJ    ZH9900_T60-0001                        Palern Ffff                " & _
" " & _
"36068     *                                         Palern Ffff         " & _
                            "ZH9900_T60(-1) " & _
                            "PLMN(-PLMN / RRRR - 1 / TNOD - 3) " & _
"EXPECTED MODULE NOT ACTIVATED                                                " & _
"Ttttttt    2010-09-28 01:01:09                                               " & _
"Myyyy ID   4889175                   " & _
"Suppl Info Control Unit 1-B/U14/IF module U10/M0 SPT:262149 Expected module not   " & _
"activated NID:3 NNM:ZH9900_T60-0001  " & _
"Diag Info  Probable cause: 0  " & _
"Rrrrrr     ZH9900_T60-0001                        EQUIPMENT           " & _
"Ctrl FF    ZH9900_T60-0001                        Palern Ffff               36100     *                                         Palern West         " & _
                            "ZH7777_T60(-1) " & _
                            "PLMN(-PLMN / RRRR - 1 / RRRR - 3) " & _
                            "UNIT(Not RESPONDING) " & _
"Ttttttt    2010-09-28 01:01:16                                               " & _
"Myyyy ID   4889178                   " & _
"Suppl Info Control Unit 1-B/U14/U10 SPT:393219 Unit not responding NID:3 NNM:ZH9  " & _
"900:                            _T60(-1) " & _
"Diag Info  Probable cause: 0  " & _
"Rrrrrr     ZH9900_T60-0001                        PROCESSING          " & _
"Ctrl NE    ZH9900_T60-0001                        Palern Ffff                 "
                            

                     

                        Dim writeRange As Excel.Range, startCell As Excel.Range, endCell As Excel.Range

                        
writeRange = .Range(.Cells(1, 1), .Cells(1, 2)) 'you might have to make some explicit conversions here, work on this if it doesn't work
                        
writeRange.Value2 = DataArray    <--------------------- after that error occurs
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
FIlling excel sheet from array problem
FIlling excel sheet from array problem
FIlling excel sheet from array problem FIlling excel sheet from array problem
FIlling excel sheet from array problem
FIlling excel sheet from array problem
FIlling excel sheet from array problem FIlling excel sheet from array problem FIlling excel sheet from array problem FIlling excel sheet from array problem FIlling excel sheet from array problem FIlling excel sheet from array problem FIlling excel sheet from array problem
FIlling excel sheet from array problem
FIlling excel sheet from array problem
 
FIlling excel sheet from array problem
FIlling excel sheet from array problem
 
-->