asp.net - how to add dataset to worksheet using Excellibrary -


I have to add multiple worksheets to a single file. I can not find a way to add dataset to the worksheet but I know

Try it out to add a worksheet. 

  using the system; Using System.Data; Using System.IO; Using ExcelLibrary.SpreadSheet; Namespace Excel Library {/// & lt; Summary & gt; /// Excel provides a simple way to convert the workbook to DataSet /// & lt; / Summary & gt; Public Sealed Class Dataset Helper {/// & lt; Summary & gt; /// In all worksheets from a given Excel workbook, /// all data (converted in all strings) /// & lt; / Summary & gt; /// & lt; Param name = "filePath" & gt; File path of excel workbook & lt; / Param & gt; /// & lt; Returns & gt; Datasets populate in Dataset with all worksheets & lt; / Returns & gt; Public statusetetsetetsetset (string filpto) {dataset ds = new dataset (); Workbook workbook = workbook Load (file path); Worksheets (worksheets in workbook) {datatable dt = populated data (ws); Ds.Tables.Add (DT); } Return DS; } /// & lt; Summary & gt; /// Arrange the work sheet name in a new example of data from a given Excel /// workbook (converted in all strings) and a new example of datatale. /// If the work sheet has been given, it receives zero. /// & lt; / Summary & gt; /// & lt; Param name = "filePath" & gt; File path of excel workbook & lt; / Param & gt; /// & lt; Param name = "sheetName" & gt; Worksheet in Workbook & lt; / Param & gt; /// & lt; Returns & gt; DataSetABL data with data & lt; / Returns & gt; Public static datatable CreateDataTable (string filespath, string sheets) {workbook workbook = workbook. Load (file path); Foreign Worksheets (Worksheets in Workbook) {if (ws.Name.Equals (sheetName)) returns PopulateDataTable (ws); } Return tap; } Private Static Datable Populate DataTable (worksheet ws) {cell collection cell = V. // Creates a data sheet from a worksheet / All values ​​strings will be treated as datatable dt = new datatile (ws.Name); // Extract column for (int i = 0; i & lt; = Cells.LastColIndex; i ++) dt.Columns.Add (cell [0, i]. Stringvalue, typef (string)); // For Extra Data (Int presentRONDEX = 1; ONLINE INDEX & lt; = Cells.LastRowIndex; currentRowIndex ++) {DataRow dr = dt.NewRow (); (Int current column index = 0; current code index & lt; = Cells.LastColIndex; current code indices ++) Dr. [current column index] = cell [currentro index, current column index]. Stringsvalue; Dt.Rows.Add (Dr.); } Return DT; } /// & lt; Summary & gt; /// Populate all the data from the given dataset in a new Excel workbook & /// & lt; / Summary & gt; /// & lt; Param name = "filePath" & gt; File path to create new Excel workbook & lt; / Param & gt; /// & lt; Param name = "dataset" & gt; Source dataset & lt; / Param & gt; Public static zero CreateWorkbook (string filpto, dataset dataset) {If (dataset.Tables.Count == 0) Exceptions to new logic ("Datasets should have at least one datatylet", "dataset"); Workbook workbook = new workbook (); Forwarding (DataTable DT Tables in Datasets) {Worksheet Worksheet = New Worksheet (DTTABNAM); (Int i = 0; i   
 By style and color  
  HSSFCellStyle style1 = hssfworkbook.CreateCellStyle (); // cell background style1 FulFireground Corollar = NPOI.HSSF.UTLHSSFCLLRLL.ExX; Style 1 Fill pattern = HSSFCellStyle.SOLID_FOREGROUND; // font color HSSF font font1 = hssfworkbook.CreateFont (); Font1.Color = NPOI.HSSF.Util.HSSFColor.YELLOW.index; Style1.SetFont (font1); Cell.CellStyle = style1;   
 See this post for more information

Comments

Post a Comment

Popular posts from this blog

python - Assemble mpeg file unable to play in mediaplayer -

I am currently working on a school project and I think that is to gather some problems with the MPEG file I The scope of my project is: 1) Split the MPEG file into pieces of many fixed sizes. 2) Collecting some of them and leaving some part. Problem 1: When I run the file in the media player, it will play the video until it reaches that segment which I left Give it Example: Chunk = ["yui_1", "yui_2", "yui_3", "yui_5", "yui_6"] Duration of each segment: 1 second * If you think I have left the "yui_4" section. * If I went to collect all the parts except "yui_4", then the video will play the first 2 seconds before being hanged throughout the period. Problem 2: When I gather the first part off the part, it is unable to run the full MPEG file is. Duration of each piece: 1 second Example: wheel = ["yui_2", "yui_3", "yui_4", "yui_5", "yui_6"...
Read more

c# - crystal report failed -

I have created a crystal report with parameters, but this does not load the value. It only shows the title, I mean column name only. Please check your code and correct me. And I tried to load that report in PDF format, which shows an error like "Load report failed" Please correct me. Protected Zero Button 2_Click (Object Sender, EventArgs E) {Report Document Reports Document = New Report Document (); Reportdocument.Load (Server.MapPath ("CrystalReport.rpt")); Reportdocument.SetDatabaseLogon ("", "", "Arvind", "My ScamDDB"); Report document. Setpermator val ("mrno", textbox 1. text); CrystalReportViewer1.ReportSource = Report Document; } Secure Zero LinkButton1_Click (Object Sender, EventArgs E) {Exportport (); Private Zero Exports () {MemoriStream Ostream; Response.Clear (); reaction. Buffer = true; Report Document Report Document = New Report Document (); Reportdocument.Load (Server.MapPath ("CrystalReor...
Read more

mongodb - CakePHP paginator ignoring order, but only for certain values -

While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
Read more