<\/div>\n

Merhaba,<\/p>\n

Ge\u00e7enlerde bir a\u011fabeyim, \u0130stanbul piyasas\u0131nda t\u00fcm raporlamalar\u0131n Excel dosyas\u0131yla yap\u0131ld\u0131\u011f\u0131n\u0131 s\u00f6yleyerek bu i\u00e7eri\u011fin anlam ve \u00f6nemine at\u0131fta bulundu\u011funu belirterek yaz\u0131m\u0131za giri\u015f yap\u0131yorum.<\/p>\n

\u0130ster rapor, isterseniz veritaban\u0131 veyahut hesaplama i\u015flemleri i\u00e7in Excel dosyas\u0131n\u0131 kullanmaktay\u0131z. Bu kadar hayat\u0131m\u0131zda olan bir dosya format\u0131nda C# ile nas\u0131l \u00e7al\u0131\u015fma ger\u00e7ekle\u015ftirece\u011fimizi inceleyece\u011fiz.<\/p>\n

\u00d6ncelikle ilgili projeye “Microsoft Excel 14.0 Object Library<\/strong><\/em>” dll dosyas\u0131n\u0131 entegre ediniz.<\/p>\n

$\"C#$ <\/a>
C# \u0130le Excel Dosyas\u0131 Olu\u015fturma<\/p><\/div>\n
Bu i\u015flemden sonra art\u0131k Excel i\u015flemlerinde kullanaca\u011f\u0131m\u0131z s\u0131n\u0131flar\u0131 a\u015fa\u011f\u0131dan inceleyebilirsiniz. Tabi bu s\u0131n\u0131flar\u0131 kullanabilmek i\u00e7in ilgili sayfaya “Microsoft.Office.Interop.Excel<\/em>” k\u00fct\u00fcphanesini ekliyoruz.<\/p>\n
\r\n Application excel = new Application();\r\n \/\/Uygulama olu\u015fturuyoruz.\r\n excel.Visible = true;\r\n \/\/Uygulamay\u0131 ba\u015flat\u0131yoruz.\r\n object Missing = Type.Missing;\r\n Workbook workbook = excel.Workbooks.Add(Missing);\r\n \/\/\u00c7al\u0131\u015fma d\u00fczenimizi olu\u015fturuyoruz.\r\n Worksheet sheet1 = (Worksheet)workbook.Sheets[1];\r\n int BaslangicKolon = 1;\r\n int BaslangicSatir = 1;\r\n \/\/******* Kolon Ekliyoruz *******\r\n ((Range)sheet1.Cells[BaslangicSatir, BaslangicKolon + 0]).Value2 = "Kolon 1";\r\n ((Range)sheet1.Cells[BaslangicSatir, BaslangicKolon + 1]).Value2 = "Kolon 2";\r\n ((Range)sheet1.Cells[BaslangicSatir, BaslangicKolon + 2]).Value2 = "Kolon 2";\r\n \/\/******* *******\r\n \/\/******* Sat\u0131r Ekliyoruz *******\r\n Range Kolon1Satir1 = (Range)sheet1.Cells[BaslangicSatir + 1, BaslangicKolon + 0];\r\n Kolon1Satir1.Value2 = "Kolon 1 Sat\u0131r 1";\r\n Kolon1Satir1.Select();\r\n\r\n Range Kolon2Satir1 = (Range)sheet1.Cells[BaslangicSatir + 1, BaslangicKolon + 1];\r\n Kolon2Satir1.Value2 = "Kolon 2 Sat\u0131r 1";\r\n Kolon2Satir1.Select();\r\n\r\n Range Kolon3Satir1 = (Range)sheet1.Cells[BaslangicSatir + 1, BaslangicKolon + 2];\r\n Kolon3Satir1.Value2 = "Kolon 3 Sat\u0131r 1";\r\n Kolon3Satir1.Select();\r\n\r\n Range Kolon1Satir2 = (Range)sheet1.Cells[BaslangicSatir + 2, BaslangicKolon + 0];\r\n Kolon1Satir2.Value2 = "Kolon 1 Sat\u0131r 2";\r\n Kolon1Satir2.Select();\r\n\r\n Range Kolon2Satir2 = (Range)sheet1.Cells[BaslangicSatir + 2, BaslangicKolon + 1];\r\n Kolon2Satir2.Value2 = "Kolon 2 Sat\u0131r 2";\r\n Kolon2Satir2.Select();\r\n\r\n Range Kolon3Satir2 = (Range)sheet1.Cells[BaslangicSatir + 2, BaslangicKolon + 2];\r\n Kolon3Satir2.Value2 = "Kolon 3 Sat\u0131r 2";\r\n Kolon3Satir2.Select();\r\n \/\/******* *******\r\n<\/pre>\n
Bu i\u015flemlerden sonra direkt olarak Excel dosyas\u0131 kar\u015f\u0131n\u0131za \u00e7\u0131kmaktad\u0131r.<\/p>\n
$\"C#$ <\/a>
C# \u0130le Excel Dosyas\u0131 Olu\u015fturma<\/p><\/div>\n
\u0130\u015fte bu kadar basit…<\/p>\n
Sonraki yaz\u0131lar\u0131mda g\u00f6r\u00fc\u015fmek \u00fczere…
\n\u0130yi \u00e7al\u0131\u015fmalar dilerim…<\/p>\n","protected":false},"excerpt":{"rendered":"
Merhaba, Ge\u00e7enlerde bir a\u011fabeyim, \u0130stanbul piyasas\u0131nda t\u00fcm raporlamalar\u0131n Excel dosyas\u0131yla yap\u0131ld\u0131\u011f\u0131n\u0131 s\u00f6yleyerek bu i\u00e7eri\u011fin anlam ve \u00f6nemine at\u0131fta bulundu\u011funu belirterek yaz\u0131m\u0131za giri\u015f yap\u0131yorum. \u0130ster rapor, isterseniz veritaban\u0131 veyahut hesaplama i\u015flemleri i\u00e7in Excel dosyas\u0131n\u0131 kullanmaktay\u0131z....<\/p>\n","protected":false},"author":1,"featured_media":3758,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[27,969,972,970,971,968,973],"class_list":["post-3753","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-c-sharp-c","tag-c","tag-c-excel","tag-c-excel-dosyasi-olusturma","tag-excel","tag-microsoft-excel","tag-microsoft-excel-14-0-object-library","tag-microsoft-office-interop-excel"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/3753","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/comments?post=3753"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/3753\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media\/3758"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=3753"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=3753"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=3753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}