{"id":141,"date":"2013-03-09T13:02:44","date_gmt":"2013-03-09T11:02:44","guid":{"rendered":"http:\/\/wintrscada.com\/?p=141"},"modified":"2021-12-18T13:30:53","modified_gmt":"2021-12-18T11:30:53","slug":"excel","status":"publish","type":"post","link":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel\/","title":{"rendered":"Excel"},"content":{"rendered":"

WinTr Scada i\u00e7ersinde bir \u00e7ok fakl\u0131 fonksiyon ile excel kullan\u0131m\u0131 m\u00fcmk\u00fcnd\u00fcr. Bu fonksiyonlar her hangi bir kod yazmaks\u0131z\u0131n WinTr scada i\u00e7ersinde otomatik olarak kullan\u0131l\u0131r. Bu b\u00f6l\u00fcmde scriptler i\u00e7ersinde Excel eri\u015fimi hakk\u0131ndaki sorular\u0131n\u0131z\u0131 yan\u0131tlayaca\u011f\u0131z.<\/p>\n

Bu konu ile alakal\u0131 sorular\u0131n\u0131z\u0131 bu b\u00f6l\u00fcmde sorabilirsiniz.<\/p>\n

A\u015fa\u011f\u0131da Excel’den veri okuyan \u00f6rnek scripti sizin i\u00e7in yazd\u0131m.
\nImports System
\nImports System.IO
\nImports System.Windows.Forms
\nImports Microsoft.VisualBasic
\nImports System.Globalization<\/p>\n

Namespace WinTr
\nPublic Class MainClass
\nPublic Tag_1 as string
\nPublic Tag_2 as string
\nPublic Sub Load
\nDim oldCulture As System.Globalization.CultureInfo = System.Threading.Thread.CurrentThread.CurrentCulture
\nTry
\nDim cultur_str As String = CultureInfo.CurrentCulture.IetfLanguageTag
\nDim Exx As New Microsoft.Office.Interop.Excel.Application
\nDim newCulture As New System.Globalization.CultureInfo(Exx.Application.LanguageSettings.LanguageID(Microsoft.Office.Core.MsoAppLanguageID.msoLanguageIDUI))
\nSystem.Threading.Thread.CurrentThread.CurrentCulture = newCulture
\nDim Exl As New Microsoft.Office.Interop.Excel.Application
\nExl.Visible =\u00a0False
\nExl.Workbooks.Open(“C:\\Book1.xlsx”)
\nTag_1 = Exl.Worksheets(1).cells(1, 1).value
\nTag_2 = Exl.Worksheets(1).cells(2, 1).value
\nExl.Quit()
\nCatch ex As Exception
\nMessageBox.Show(Ex.ToString,Ex.Message)
\nEnd Try
\nSystem.Threading.Thread.CurrentThread.CurrentCulture = oldCulture
\nEnd Sub
\nEnd Class
\nEnd Namespace<\/p>\n

Bu sat\u0131r veriyi okuyan sat\u0131rd\u0131r. Veri yazmak i\u00e7in e\u015fittirin sol ve sa\u011f taraflar\u0131n\u0131 yer de\u011fi\u015ftirmek gerekir.
\nExl.Worksheets(1).cells(1, 1).value = Tag_1<\/p>\n

\n\t\t\t\t\t
Kodu kopyalay\u0131p yap\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda \u00e7ift t\u0131rnak i\u015faretlerini yeniden yaz\u0131n\u0131z. Baz\u0131 sat\u0131rlar iki’ye b\u00f6l\u00fcnerek iki sat\u0131r \u015feklinde yap\u0131\u015ft\u0131r\u0131lm\u0131\u015f olabilir, kontrol ediniz.<\/div><\/div>\n
\n\t\t\t\t\t
Bu kod ile harddisk’de bulunan bir excel dosyas\u0131 a\u00e7\u0131l\u0131r okuma veya yazma yap\u0131l\u0131p kapat\u0131l\u0131r. Excel ile scada’n\u0131n birlikte \u00e7al\u0131\u015fmas\u0131 baz\u0131 s\u0131k\u0131nt\u0131lar olu\u015fturabilir. Excel’in bir \u00e7ok farkl\u0131 versiyonunun farkl\u0131 s\u0131k\u0131nt\u0131lar\u0131 var. \u00d6rne\u011fin 2010 \u00f6ncesindeki versiyonlarda excel dilinin pek \u00f6nemi yoktu. Daha sonra dil \u00f6nemli oldu. G\u00f6nderdi\u011fim kod’da sistem dili oldcultre de\u011fi\u015fkenine kaydediliyor. Excel dili \u00f6\u011frenip dil de\u011fi\u015ftiriliyor. okuma veya yazma bittikten sonra dil tekrar eski haline al\u0131n\u0131yor. G\u00f6nderdi\u011fim kod t\u00fcm versiyonlar i\u00e7in \u00e7al\u0131\u015faca\u011f\u0131n\u0131 d\u00fc\u015f\u00fcn\u00fcyorum.<\/p><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

WinTr Scada i\u00e7ersinde bir \u00e7ok fakl\u0131 fonksiyon ile excel kullan\u0131m\u0131 m\u00fcmk\u00fcnd\u00fcr. Bu fonksiyonlar her hangi bir kod yazmaks\u0131z\u0131n WinTr scada i\u00e7ersinde otomatik olarak kullan\u0131l\u0131r. Bu b\u00f6l\u00fcmde scriptler i\u00e7ersinde Excel eri\u015fimi hakk\u0131ndaki sorular\u0131n\u0131z\u0131 yan\u0131tlayaca\u011f\u0131z. Bu konu ile alakal\u0131 sorular\u0131n\u0131z\u0131 bu b\u00f6l\u00fcmde sorabilirsiniz. A\u015fa\u011f\u0131da Excel’den veri okuyan \u00f6rnek scripti sizin i\u00e7in yazd\u0131m. Imports System Imports System.IO Imports […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_swpsp_post_exclude":false,"footnotes":""},"categories":[31],"tags":[104,103],"class_list":["post-141","post","type-post","status-publish","format-standard","hentry","category-scada-excel","tag-excel-scriptleri","tag-scada-excel-2"],"yoast_head":"\nExcel - SCADA E\u011fitim Sitesi<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel\/\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Salih\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/excel\\\/\"},\"author\":{\"name\":\"Salih\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#\\\/schema\\\/person\\\/b439f08807fdc9e273a233976c5eb1be\"},\"headline\":\"Excel\",\"datePublished\":\"2013-03-09T11:02:44+00:00\",\"dateModified\":\"2021-12-18T11:30:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/excel\\\/\"},\"wordCount\":396,\"commentCount\":0,\"keywords\":[\"Excel Scriptleri\",\"Scada Excel\"],\"articleSection\":[\"Excel\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/excel\\\/\",\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/excel\\\/\",\"name\":\"Excel - SCADA E\u011fitim Sitesi\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#website\"},\"datePublished\":\"2013-03-09T11:02:44+00:00\",\"dateModified\":\"2021-12-18T11:30:53+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#\\\/schema\\\/person\\\/b439f08807fdc9e273a233976c5eb1be\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/excel\\\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/excel\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#website\",\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/\",\"name\":\"SCADA E\u011fitim Sitesi\",\"description\":\"SCADA program\u0131 hakk\u0131nda bilmek istedikleriniz.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#\\\/schema\\\/person\\\/b439f08807fdc9e273a233976c5eb1be\",\"name\":\"Salih\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g\",\"caption\":\"Salih\"},\"sameAs\":[\"http:\\\/\\\/www.fultek.com.tr\"],\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/author\\\/salih\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel - SCADA E\u011fitim Sitesi","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel\/","twitter_misc":{"Yazan:":"Salih","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel\/#article","isPartOf":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel\/"},"author":{"name":"Salih","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#\/schema\/person\/b439f08807fdc9e273a233976c5eb1be"},"headline":"Excel","datePublished":"2013-03-09T11:02:44+00:00","dateModified":"2021-12-18T11:30:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel\/"},"wordCount":396,"commentCount":0,"keywords":["Excel Scriptleri","Scada Excel"],"articleSection":["Excel"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel\/","url":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel\/","name":"Excel - SCADA E\u011fitim Sitesi","isPartOf":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#website"},"datePublished":"2013-03-09T11:02:44+00:00","dateModified":"2021-12-18T11:30:53+00:00","author":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#\/schema\/person\/b439f08807fdc9e273a233976c5eb1be"},"breadcrumb":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fultek.com.tr\/scada-yardim\/"},{"@type":"ListItem","position":2,"name":"Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#website","url":"https:\/\/www.fultek.com.tr\/scada-yardim\/","name":"SCADA E\u011fitim Sitesi","description":"SCADA program\u0131 hakk\u0131nda bilmek istedikleriniz.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fultek.com.tr\/scada-yardim\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#\/schema\/person\/b439f08807fdc9e273a233976c5eb1be","name":"Salih","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/secure.gravatar.com\/avatar\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g","caption":"Salih"},"sameAs":["http:\/\/www.fultek.com.tr"],"url":"https:\/\/www.fultek.com.tr\/scada-yardim\/author\/salih\/"}]}},"_links":{"self":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts\/141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/comments?post=141"}],"version-history":[{"count":6,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts\/141\/revisions"}],"predecessor-version":[{"id":815,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts\/141\/revisions\/815"}],"wp:attachment":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/media?parent=141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/categories?post=141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/tags?post=141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}