NanaYee

Do you mean to write data in different worksheets? How about this? Workbook workbook = new Workbook(); //sheet 1 Worksheet sheet = workbook.Worksheets[0]; sheet.Range["A1"].Text="First name"; //sheet 2 Worksheet sheet2 = workbook.Worksheets[1]; sheet2.Range["A1"].Text="Last Name"; I use [.NET Excel](http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html) library

I create an Excel file with a header data "TRANSACTION DATA FOR CDs MANAGED BY TCBILs FOR THE MONTH OF DECEMBER 2012" and export to datagrid with the no shorten. My code below: Workbook workbook = new Workbook(); workbook.LoadFromFile(@"..\..\Test.xlsx"); Worksheet sheet = workbook.Worksheets[0]; this.dataGridView1.DataSource = sheet.ExportDataTable(); I use a compnent …

Search Text: Document document = new Document(); document.LoadFromFile(@"..\..\test.doc"); TextSelection[] textSelections = document.FindAllString("xyz.Text, true, true); I use a [C# Word](http://www.e-iceblue.com/Introduce/word-for-net-introduce.html) DLL.

Hello, This is my method to convert .TXT to .PDF. //Load string text = File.ReadAllText(@"E:\Sample.txt"); //Create PDF Template PdfDocument document = new PdfDocument(); PdfSection section = document.Sections.Add(); ; PdfPageBase page = section.Pages.Add(); PdfFont font = new PdfFont(PdfFontFamily.Helvetica, 11); PdfStringFormat format = new PdfStringFormat(); format.LineSpacing = 20f; float pageWidth = page.Canvas.ClientSize.Width; …

Code here: System.Data.OleDb.OleDbConnection oleDbConnection1 = new System.Data.OleDb.OleDbConnection(); oleDbConnection1.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=File Path"; System.Data.OleDb.OleDbCommand oleDbCommand1 = new System.Data.OleDb.OleDbCommand(); oleDbCommand1.CommandText = "select * from Table"; oleDbCommand1.Connection = oleDbConnection1; Spire.DataExport.TXT.TXTExport txtExport1 = new Spire.DataExport.TXT.TXTExport(); txtExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView; txtExport1.DataEncoding = Spire.DataExport.Common.EncodingType.ASCII; txtExport1.SQLCommand = oleDbCommand1; oleDbConnection1.Open(); txtExport1.ExportType = Spire.DataExport.TXT.TextExportType.CSV; txtExport1.FileName = "sample.csv"; txtExport1.SaveToFile(); [DataExport component](http://www.e-iceblue.com/Introduce/data-export-for-net-intro.html) …

[url]http://www.codeproject.com/KB/cs/Excel_PDF_Word_ExportWiz.aspx?fid=1607512&df=90&mpp=25&noise=3&sort=Position&view=Quick&fr=1#xx0xx[/url] The method in this article is also very useful!