Export data from OpenOffice Excel sheet into DataTable/Dataset

Posted by Santhoshalla under WPF on 2/9/2013 | Points: 10 | Views : 3125 | Status : [Member] | Replies : 5
I have a OpenOffice Excel Sheet
that contains State,District,Taluka,Zone,Region and Territory

exprot these file into datatable or dataset

How it possible.

and while using open office in .net that contains any separate assembley.

Please give my full information.




Responses

Posted by: Rimi1289 on: 2/9/2013 [Member] Starter | Points: 25

Up
0
Down
You did not mention which platform you are using.

Rimi

Santhoshalla, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Santhoshalla on: 2/9/2013 [Member] Starter | Points: 25

Up
0
Down
I am using windows Forms using C# VS.4.0

export data from OpenOffice Excel sheet to DataTable/Dataset



Santhoshalla, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rimi1289 on: 2/9/2013 [Member] Starter | Points: 25

Up
0
Down
@ Santhoshalla,
Did the above links helped you in any ways.

Rimi

Santhoshalla, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Santhoshalla on: 2/9/2013 [Member] Starter | Points: 25

Up
0
Down
No.
just i want to store excel data in datatable/dataset (here am taking oledbconnection)
then i want to use that object in my shape file creation application
My total environment is windows forms using C# VS (4.0)

Please help me.

Santhoshalla, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Santhoshalla on: 2/9/2013 [Member] Starter | Points: 25

Up
0
Down
No.
just i want to store excel data in datatable/dataset (here am taking oledbconnection)
then i want to use that object in my shape file creation application
My total environment is windows forms using C# VS (4.0)

Please help me.

Santhoshalla, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response