open a csv-file with excel using netoffice
open a csv-file with excel using netoffice
open a csv-file with excel using netoffice
open a csv-file with excel using netoffice
open a csv-file with excel using netoffice
open a csv-file with excel using netoffice open a csv-file with excel using netoffice open a csv-file with excel using netoffice open a csv-file with excel using netoffice open a csv-file with excel using netoffice open a csv-file with excel using netoffice open a csv-file with excel using netoffice open a csv-file with excel using netoffice
open a csv-file with excel using netoffice open a csv-file with excel using netoffice
open a csv-file with excel using netoffice
Go Back  Xtreme Visual Basic Talk > > > open a csv-file with excel using netoffice


Reply
 
Thread Tools Display Modes
  #1  
Old 03-25-2013, 01:26 PM
oop oop is offline
Newcomer
 
Join Date: Mar 2013
Posts: 5
Question open a csv-file with excel using netoffice


Hello everybody,
apologize If this question were already answerd. I searchd a long time but could not find an answer.
Thats the way I open those csv-file(using netoffice). It works fine, but it put all in the first cell, its not as I get it before, when I used the Excel Library instead of Netoffice.
It doesn't matter, if I choose number '2' or '1' . On any side I read, that this shal be a critical for those letter inside of taht csv-file( , or ;)

Code:
Public Sub openCSV(ByVal CsvFile As String)
            
            Dim appEx As Excel.Application
            Try
                appEx = New Excel.Application()
                Dim myWB As Excel.Workbook = appEx .Workbooks.Open(CsvFile , 2)

            Catch ex As Exception
                MessageBox.Show("Error=" & ex.Message)
            Finally
                If Not appEx Is Nothing Then appEx = Nothing
            End Try
End Sub
Reply With Quote
  #2  
Old 03-28-2013, 06:39 PM
oop oop is offline
Newcomer
 
Join Date: Mar 2013
Posts: 5
Default

"LateBindingApi" shal be a solution, but doesn't exist in "NetOffice 1.5.1.2 [RC]"
Reply With Quote
  #3  
Old 03-30-2013, 12:23 PM
oop oop is offline
Newcomer
 
Join Date: Mar 2013
Posts: 5
Default

I have downloadd LateBindingApi 7.00, even I did not see the point. Cause its hard to believe, that this is sepperate from netoffice package.
Well, set the reference, but at last "Core" is not a member, as it has to be like this example
LateBindingApi.Core.Factory.Initialize();
XLApp = new Excel.Application(null, ExcelDnaUtil.Application);

This shall be the way to open an csv file, if you want it, as you get it with excel library.

Its hard, that such an basic stuff is for digg out deply
Reply With Quote
  #4  
Old 04-13-2013, 03:43 PM
oop oop is offline
Newcomer
 
Join Date: Mar 2013
Posts: 5
Default

I fell greater than ever, cause have had a question, who none could answer.
And now I found out the reason for that problem, but I fear I'm to stuppid to explain it.
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
open a csv-file with excel using netoffice
open a csv-file with excel using netoffice
open a csv-file with excel using netoffice open a csv-file with excel using netoffice
open a csv-file with excel using netoffice
open a csv-file with excel using netoffice
open a csv-file with excel using netoffice open a csv-file with excel using netoffice open a csv-file with excel using netoffice open a csv-file with excel using netoffice open a csv-file with excel using netoffice open a csv-file with excel using netoffice open a csv-file with excel using netoffice
open a csv-file with excel using netoffice
open a csv-file with excel using netoffice
 
open a csv-file with excel using netoffice
open a csv-file with excel using netoffice
 
-->