C# et Visual express 2013

http://www.microsoftvirtualacademy.com/training-courses/c-fundamentals-for-absolute-beginners?m=7665&ct=27107

http://www.geekinterview.com/question_details/5532

Microsoft.Office.Interop.excel
http://www.dotnetperls.com/excel

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
//using Excel = Microsoft.Office.Interop.Excel;
using System.Reflection;
using Microsoft.Office.Interop.Excel; 
   

class Program
{
    const string fileName = "D:\\Book2.xlsx";
    const string topLeft = "A1";
    const string bottomRight = "A4";
    const string graphTitle = "Graph Title";
    const string xAxis = "Time";
    const string yAxis = "Value";

    static void Main()
    {
        // Open Excel and get first worksheet.
        var application = new Application();
        var workbook = application.Workbooks.Open(fileName);
        var worksheet = workbook.Worksheets[1] as
            Microsoft.Office.Interop.Excel.Worksheet;

        // Add chart.
        var charts = worksheet.ChartObjects() as
            Microsoft.Office.Interop.Excel.ChartObjects;
        var chartObject = charts.Add(60, 10, 300, 300) as
            Microsoft.Office.Interop.Excel.ChartObject;
        var chart = chartObject.Chart;

        // Set chart range.
        var range = worksheet.get_Range(topLeft, bottomRight);
        chart.SetSourceData(range);

        // Set chart properties.
        chart.ChartType = Microsoft.Office.Interop.Excel.XlChartType.xlLine;
        chart.ChartWizard(Source: range,
            Title: graphTitle,
            CategoryTitle: xAxis,
            ValueTitle: yAxis);

        // Save.
        workbook.Save();
    }
}
   


http://www.codeproject.com/Questions/695539/How-to-copy-data-from-one-excel-sheet-to-another

STATIC , PUBLIC :  http://msdn.microsoft.com/en-us/library/79b3xss3.aspx



Aucun commentaire:

Enregistrer un commentaire