You must Sign In to post a response.
  • Category: .NET

    How to Generate Excel in the format of .xlsb in vb.net

    Hi friends,
    I know how to generate excel in the format of .xls and .xlsx in vb.net with the help of Miscrosoft Provider oledb 12.0. But i need to generate the Excel in the format of .xlsb format. Kindly guide me to do this.


    Regads,
    Karunanidhi.K
  • #761477
    Hello,

    Basically there are two ways to transfer your data to excel formats.
    1. You can use the dlls of excel and few lines of code.
    2. You can use crystal report or RDLC report and use the option of export.

    Still you face the problem then let me know.

    Regards,
    Dhiraj C. Solanki

  • #763706
    Hi there,

    No idea about how to create .xlsb format file with Microsoft Provider oledb, but I do have some experience with Spire.XLS, which enables users to transfer data to Excel and save as plenty of formats such as .xls, .xlsx, .xlsb. You can have a try.

    http://spreadsheet.codeplex.com/


Sign In to post your comments