Changes in already excisted excel file
-
Hi i have a Already existed excel file in my root path of the application, In tht i have to clear particular cells range like A2 to F75. And i have insert my new datas into those cells,after tht its has to getting save on enduser side, Please guide me,any one having idea baout this Thanks & Regards, Member 3879881, please don't forget to vote on the post
-
Hi i have a Already existed excel file in my root path of the application, In tht i have to clear particular cells range like A2 to F75. And i have insert my new datas into those cells,after tht its has to getting save on enduser side, Please guide me,any one having idea baout this Thanks & Regards, Member 3879881, please don't forget to vote on the post
Start with Google results for "c# excel"[^] and then "C# excel set call value"[^]. Any changes you make to the files cannot be done while the file is open. All users have to close the file before you can make changes to it.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak -
Hi i have a Already existed excel file in my root path of the application, In tht i have to clear particular cells range like A2 to F75. And i have insert my new datas into those cells,after tht its has to getting save on enduser side, Please guide me,any one having idea baout this Thanks & Regards, Member 3879881, please don't forget to vote on the post
This is a good starting point: http://csharp.net-informations.com/excel/csharp-open-excel.htm[^] The UsedRange property of Microsoft.Office.Interop.Excel.Worksheet gives the cells that have values. The Microsoft.Office.Interop.Excel.Range type represents ranges of cells. The Cells property of Range is a two-dimensional array that lets you access individual cells. The Value2 property of a Range representing a single cell gives you the value of that cell.