C# Tutorial 28: Create Excel (.XLS and .XLSX) file from C# Using excellibrary

Поділитися
Вставка
  • Опубліковано 19 гру 2024

КОМЕНТАРІ • 32

  • @tahmaseb12
    @tahmaseb12 10 років тому +3

    If you want to use the considered package (Excel library):
    In Office 2010 the Excel file is corrupt. To fix this problem, add like 100 rows to the file and it will open in Excel 2010. Or use Office 2007/OpenOffice. Here the code to generate 100 rows:
    for (int x = 0; x < 100; x++) { worksheet.Cells[x, 0] = new Cell("Row "+ x +"; Col: 0;"); }
    Great tutorials, very clear and understandable! Keep up the good work!!!

    • @diegobernal334
      @diegobernal334 6 років тому

      its works but why i have todo that, thanks

  • @RashidAli-oc6yl
    @RashidAli-oc6yl 2 роки тому

    Great job sir

  • @JorgeRosa
    @JorgeRosa 8 років тому

    Thanks for the video. Great tutorial, helped me a lot! :)

  • @davidstaub8572
    @davidstaub8572 10 років тому +1

    No need to move around your cursor. The yellow bubble makes it very clear where the cursor is located.

  • @johnnybio1
    @johnnybio1 10 років тому

    im trying to make an application to log drivers times to a excel file then print is that possible like i have a form layout with drivers names on buttons and i want to click the button and it logs to the file by its self

  • @PhilAlbu
    @PhilAlbu 11 років тому +1

    wooooow your highlighted mouse buzzing back and forth is super annoying!
    other than that, good tutorial

  • @naixloon
    @naixloon 10 років тому

    Hello , any code to replace current spreadsheet ? mean that, i already have 1 worksheet at worksheet(6) but i need to remove it and generate a new worksheet into the same excel file . please help urgent, thank you

  • @백억사나이
    @백억사나이 11 років тому


    When will Excel 2013 (.xlsx) be supported?

  • @alekst03
    @alekst03 11 років тому

    When will Excel 2010 be supported?

  • @tranduc-camera-giam-sat
    @tranduc-camera-giam-sat 11 років тому

    I can edit an xls file with this. But the format of all cells are gone. All cells bacome unformated (or default format)

  • @charmainemeria-vivas7389
    @charmainemeria-vivas7389 10 років тому +1

    What I got after running this is just a blank sheet - no cells... nothing :(

  • @fifiball1
    @fifiball1 8 років тому

    can you tell me the commands for saving the excel?

  • @FarhanaAfrin
    @FarhanaAfrin 10 років тому

    Thank you for your excellent video. But I can't open the file with my office 2010.

    • @HuyNguyen-vp7eb
      @HuyNguyen-vp7eb 10 років тому

      yea, it happen to me too, it seem exellibrary doesnt suitable to office 2010

    • @tahmaseb12
      @tahmaseb12 10 років тому

      I have the same problem with office 2013 :(

    • @tahmaseb12
      @tahmaseb12 10 років тому +1

      If you want to use the considered package (Excel library):
      In Office 2010 the Excel file is corrupt. To fix this problem, add like 100 rows to the file and it will open in Excel 2010. Or use Office 2007/OpenOffice. Here the code to generate 100 rows:
      for (int x = 0; x < 100; x++) { worksheet.Cells[x, 0] = new Cell("Row "+ x +"; Col: 0;"); }
      Great tutorials, very clear and understandable! Keep up the good work!!!

  • @truptitatkare8784
    @truptitatkare8784 9 років тому

    can you help me to save excel file on client desktop using C#

  • @bkboggy
    @bkboggy 10 років тому +1

    You need to stop moving your mouse cursor sporadically. You do it in every video - gives me a headache. Other than that, thanks for the video.

  • @greatsea
    @greatsea 10 років тому +1

    i did this and get a blank cell-less sheet

  • @guvencdik3395
    @guvencdik3395 11 років тому

    Anybody know how to give names to cell ranges??

  • @eshansingh1
    @eshansingh1 10 років тому +1

    This is slow. Very slow. My goodness.

  • @phillisshayi7441
    @phillisshayi7441 8 років тому

    it looks like it doesn't support 2013

  • @ajerxd666
    @ajerxd666 10 років тому

    Pls share dll