If you're trying to insert data into a pre-formatted Excel worksheet, the easiest way would be to have a dummy sheet to which you import the new dataset and have the display sheet simply reference that. So your main sheet B6 would contain 'DummySheet'!A1, for example.
On Friday, June 1, 2012 4:33:41 PM UTC+1, sur aj wrote: > > > Dear friends, > > I need to insert data into particular cells of excel sheet like starting > from B6. > > I have the data that need to be inserted in a dataset. How can I insert > data into the excel sheet from the dataset. > > I am using Oledb connection. > > Regards, > > Vikas > > -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to dotnetdevelopment@googlegroups.com To unsubscribe from this group, send email to dotnetdevelopment+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net