Click here to Skip to main content
15,867,568 members
Home / Discussions / C#
   

C#

 
GeneralRe: Changing the properties of multiple labels in some kind of loop? Pin
Ron_UK16-Nov-20 5:40
Ron_UK16-Nov-20 5:40 
AnswerRe: Changing the properties of multiple labels in some kind of loop? Pin
Gerry Schmitz16-Nov-20 7:13
mveGerry Schmitz16-Nov-20 7:13 
QuestionHow to make a dll library? Pin
Alex Dunlop16-Nov-20 0:22
Alex Dunlop16-Nov-20 0:22 
AnswerRe: How to make a dll library? Pin
Richard MacCutchan16-Nov-20 0:44
mveRichard MacCutchan16-Nov-20 0:44 
GeneralRe: How to make a dll library? Pin
Alex Dunlop16-Nov-20 0:47
Alex Dunlop16-Nov-20 0:47 
GeneralRe: How to make a dll library? Pin
Richard MacCutchan16-Nov-20 0:51
mveRichard MacCutchan16-Nov-20 0:51 
AnswerRe: How to make a dll library? Pin
OriginalGriff16-Nov-20 0:50
mveOriginalGriff16-Nov-20 0:50 
GeneralRe: How to make a dll library? Pin
Alex Dunlop16-Nov-20 1:51
Alex Dunlop16-Nov-20 1:51 
I tried the following class code. Now, my problem is that "Rows" and "Columns" have red underline. They have not been defined in my class while I have used Microsoft Office Excel 16 object reference.
How can I sole those red underlines?
My updated code:
C#
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace DataGridView
{
    class ExcelExport
    {

        public void Export(string fileName, string DataSource,string FileName)
        {
            /*fileName is the name of the file will be written.
            DataSource is the DataGridView name used*/
            Microsoft.Office.Interop.Excel._Application app = new Microsoft.Office.Interop.Excel.Application();
            Microsoft.Office.Interop.Excel._Workbook workbook = app.Workbooks.Add(Type.Missing);
            Microsoft.Office.Interop.Excel._Worksheet worksheet = null;
            worksheet = workbook.Sheets["Sheet1"];
            worksheet = workbook.ActiveSheet;
            worksheet.Name = fileName;
            for (int i = 1; i < DataSource.Columns.Count + 1; i++)
            {
                worksheet.Cells[1, i] = DataSource.Columns[i - 1].HeaderText;
            }
            for (int i = 0; i < DataSource.Rows.Count; i++)
            {
                for (int j = 0; j < DataSource.Columns.Count; j++)
                {
                    worksheet.Cells[i + 2, j + 1] = DataSource.Rows[i].Cells[j].Value.ToString();
                }
            }
            var saveFileDialoge = new SaveFileDialog();
            saveFileDialoge.FileName = FileName;
            saveFileDialoge.DefaultExt = ".xlsx";
            if (saveFileDialoge.ShowDialog() == DialogResult.OK)
            {
                workbook.SaveAs(saveFileDialoge.FileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

            }
        }
    }
}

GeneralRe: How to make a dll library? Pin
OriginalGriff16-Nov-20 2:17
mveOriginalGriff16-Nov-20 2:17 
GeneralRe: How to make a dll library? Pin
Alex Dunlop16-Nov-20 2:25
Alex Dunlop16-Nov-20 2:25 
GeneralRe: How to make a dll library? Pin
OriginalGriff16-Nov-20 2:41
mveOriginalGriff16-Nov-20 2:41 
GeneralRe: How to make a dll library? Pin
Alex Dunlop16-Nov-20 2:48
Alex Dunlop16-Nov-20 2:48 
GeneralRe: How to make a dll library? Pin
OriginalGriff16-Nov-20 2:50
mveOriginalGriff16-Nov-20 2:50 
GeneralRe: How to make a dll library? Pin
Alex Dunlop16-Nov-20 3:09
Alex Dunlop16-Nov-20 3:09 
GeneralRe: How to make a dll library? Pin
OriginalGriff16-Nov-20 3:40
mveOriginalGriff16-Nov-20 3:40 
GeneralRe: How to make a dll library? Pin
Alex Dunlop16-Nov-20 4:15
Alex Dunlop16-Nov-20 4:15 
GeneralRe: How to make a dll library? Pin
OriginalGriff16-Nov-20 4:37
mveOriginalGriff16-Nov-20 4:37 
GeneralMessage Closed Pin
16-Nov-20 5:23
Alex Dunlop16-Nov-20 5:23 
GeneralRe: How to make a dll library? Pin
OriginalGriff16-Nov-20 5:41
mveOriginalGriff16-Nov-20 5:41 
GeneralRe: How to make a dll library? Pin
OriginalGriff16-Nov-20 2:21
mveOriginalGriff16-Nov-20 2:21 
QuestionC# WPF MenuItem Control not working Pin
Member 783087415-Nov-20 9:01
Member 783087415-Nov-20 9:01 
AnswerRe: C# WPF MenuItem Control not working Pin
Mycroft Holmes15-Nov-20 11:03
professionalMycroft Holmes15-Nov-20 11:03 
GeneralRe: C# WPF MenuItem Control not working Pin
Member 783087417-Nov-20 14:51
Member 783087417-Nov-20 14:51 
QuestionHow to group an array list, within a list of records, Linq GroupBy Pin
jkirkerx14-Nov-20 13:29
professionaljkirkerx14-Nov-20 13:29 
AnswerRe: How to group an array list, within a list of records, Linq GroupBy Pin
Gerry Schmitz14-Nov-20 22:31
mveGerry Schmitz14-Nov-20 22:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.