Kadang-kadang sebuah aplikasi yang kita buat membutuhkan sebuah proses untuk print/cetak dokumen. walaupun di csharp sudah ada mekanisme tersendiri untuk melakukan print documnet, pada tutorial kali ini akan dibuat sebuah print dokument menggunakan interop office (memanggil dan menjalakan office), misalnya ada sebuah aplikasi sistem informasi karyawan, akan dibuat sebuah fitur tambahan dalam sistem informasi tersebut sehingga user dapat mencetak profile karyawan kedalam word sebelum akhirnya profile karyawan tersebut di cetak.
Untuk menjalankan interop office langkah pertama yang harus dilakukan adalah melakukan "add reference" microsoft excel dari local komputer ke project yang akan dibangun, tentunya sebelum itu microsoft excel sudah terinstall.Perlu diketahui sebelumnya bahwa jika di local komputer kita terinstall office 2013 maka interop excel ini hanya bisa dijalankan di komputer yang terinstall office 2013, apabila add reference yang digunakan adalah office 2010 maka program hanya akan berjalan di office 2010 dan 2013, jika add reference yang dilakukan adalah office 2007 maka program mampu berjalan pada office 2007, 2010 dan juga 2013. maka dari disarankan melakukan add reference type office 2007 atau 2003, sehingga program akan mampu berjalan di semua versi office yang ada. Untuk lebih meningkatkan portabilitas program, silahkan gunakan target framework 4.0 atau diatasnya.
Berikut ini adalah potongan code program yang digunakan dan penjelasan singkat tentang code program tersebut.
Pada gambar dibawah ini menunjukan reference yang kita tambahkan secara manual, dari sini terlihat kalau proses penambahan add reference telah berhasil dilakukan.
gambar1. Add reference office ke project
Gambar 2. Menambahkan reference code program
Berikut ini adalah function-function yang digunakan dalam program. dari gambar dibawah ini terlihat bawah ada 4 function, 1 event button. identitas, pendidikan dan SK adalah struct yang digunakan untuk menampung data yang akan dicetak ke excel. Function runningExcel merupakan function utama di program ini, dimana fucntion ini yang menjalankan program excel serta sekaligus melakukan passing data ke microsoft excel yang telah dibuka. function releaseObject adalah function yang digunakan untuk membebaskan memori-memori yang digunakan, sedangkan function BorderArround digunakan untuk proses membuat tabel pada excel.
gambar 3. Full function yang digunakan di program
proses pembuatas program sudah selesai, jika program dijalankan kurang lebih hasilnya seperti pada gambar dibawah ini.
Gambar4. Tampilan program ketika pertama kali dijalankan
Gambar 5. Hasil Running Excel
Untuk lebih memudahkan dalam memahami tutorial ini silahkan perhatikan video dibawah ini, link download juga tersedia di video dibawah ini. Dalam tutorial ini menggunakan Visual Studio 2013 dengan microsoft office 2013
Artikel Terkait
- Sistem Informasi Insert, Update, Delete MYSQL di C Sharp (C#)
- menjalankan semua perintah command prompt di C# (C Sharp)
- membuat form login database mysql di C# (C Sharp)
- membuat form login dengan database Mysql di C# ( C Sharp )
- koneksi C# dengan SQL SERVER dan mengambil data dari SQL SERVER
- Koneksi embeded database SQLITE di C# (C Sharp)
siang mas .. apakah saya bisa program lengkapnya untuk materi ini jika bisa kirimkan kemail saya ini : oktavianaelsarika@gmail.com . mohon perhatianx dan trima kasih
BalasHapusLink download ada di tutorial video. Silahkan di coba download lagi
BalasHapusnumpang sedot gan.
BalasHapusTerimakasih mas, http://www.csharp-indonesia.com/ sangat membantu saya untuk mempelajari C#
BalasHapusKomentar ini telah dihapus oleh pengarang.
BalasHapusgak bisa terbuka bg formnya.. kasih saran bg..
BalasHapusbang bisa di kirim kah bang full projectnya ke email saya zharkhashi@gmail.com , kalau ikhlas kirim yah bang, untuk belajar , salam programmers indonesia, sekalian bang minta pinnya hehe buat tanya2 . . makasih bang
BalasHapus2guowenhao0827
BalasHapusherve leger
thomas sabo uk
nba jerseys, http://www.nbajerseys.us.com
cartier love bracelet
burberry outlet
cheap jordans
tory burch outlet
cartier bracelet
true religion outlet, http://www.truereligionoutletstore.us.com
christian louboutin,louboutin,louboutin outlet,louboutin outlet italia,scarpe louboutin
michael kors outlet, http://www.michaelkorsoutlet-store.us.com
oakland raiders jerseys
lacoste outlet
adidas outlet
ugg outlet, http://www.uggsoutlet.us.org
cheap mlb jerseys
tiffany and co
air max 2015
ugg boots clearance,ugg australia,uggs on sale,ugg slippers,uggs boots,uggs outlet,ugg boots,ugg,uggs
ray ban sunglasses
cheap oakley sunglasses, http://www.oakleysunglasses-outlet.us.com
pandora
the north face jackets
cheap wedding dresses
coach outlet store
jordan shoes, http://www.jordan-shoes.us.com
ray-ban sunglasses, http://www.ray-bansunglassess.in.net
coach outlet online
coach factory outlet
snapback hats
rolex watches,rolex watches,swiss watches,watches for men,watches for women,omega watches,replica watches,rolex watches for sale,rolex replica,rolex watch,cartier watches,rolex submariner,fake rolex,rolex replica watches,replica rolex
coach outlet
kansas city chiefs jerseys
lululemon outlet
five fingers shoes
chenlina20150916
BalasHapusnike huarache trainers
nike roshe run
p90x workouts
air max 95
rolex watches
nike trainers
barbour uk
nike store uk
polo outlet
nike tn
ralph lauren polos shirts
rolex replica watches
adidas original trainers
ugg sale
ugg boots
hermes belt
supra shoes
celine handbags
ralph lauren
ed hardy clothing
as
qihang1005,insanity workout
BalasHapusreplica watches
air force 1
jordan shoes
mont blanc pens
hollister kids
kobe bryant shoes
adidas superstar
ray ban sunglasses outlet
tommy hilfiger outlet
pandora
ray-ban sunglasses
canada goose outlet
nike cortez
kate spade outlet
fake oakley sunglasses
pandora bracelets
prada
ed hardy clothing
vans shoes
michael kors
nike trainers
michael kors handbags
nike running shoes
ralph lauren outlet
burberry outlet
pandora charms
toms outlet
nike elite socks
instyler curling iron
moncler jackets
louboutin
coach outlet
tod's shoes
mcm outlet
mizuno running shoes
coach outlet canada
q
2015-11-24 xiaozhengm
BalasHapussac longchamp pliage
longchamp handbags
jordan 13
coach outlet
pandora jewelry
coach factory outlet
nike uk
michael kors outlet
coach outlet
oakley sunglasses
ugg boots
christian louboutin outlet
jordan 6
sac longchamp pas cher
nike air max
oakley sunglasses
michael kors outlet online
michael kors handbags
michael kors outlet online
coach outlet
coach outlet
gucci outlet
coach outlet
ghd straighteners
canada gooses outlet
barbour uk
mizuno running shoes
tory burch outlet
ray ban
christian louboutin outlet
michael kors outlet
michael kors
michael kors
nike tn
running shoes
adidas outlet store
christian louboutin
cheap oakley sunglasses
christian louboutin uk
gucci outlet
ninest123 12.15
BalasHapusoakley sunglasses, louboutin shoes, michael kors outlet online, prada outlet, louis vuitton outlet online, oakley sunglasses, nike free, oakley sunglasses, replica watches, burberry outlet, christian louboutin, nike air max, tiffany jewelry, tiffany jewelry, ralph lauren outlet, ray ban sunglasses, burberry factory outlet, cheap jordans, longchamp outlet, michael kors, ralph lauren polo, michael kors outlet online, replica watches, gucci handbags, michael kors outlet, ray ban sunglasses, uggs on sale, michael kors handbags, nike outlet, nike air max, uggs on sale, uggs outlet, christian louboutin, prada handbags, uggs outlet, tory burch outlet, louis vuitton outlet, louboutin uk, longchamp bags, longchamp outlet, ray ban sunglasses, cheap oakley sunglasses, louis vuitton handbags, oakley sunglasses, louis vuitton, uggs on sale, michael kors outlet online, louis vuitton outlet
louboutin pas cher, timberland pas cher, nike trainers uk, true religion jeans, nike roshe run pas cher, nike air max pas cher, nike blazer pas cher, lunette ray ban pas cher, abercrombie and fitch, lululemon outlet, michael kors outlet online, michael kors, coach outlet store online, coach purses, new balance, nike air max, hollister uk, michael kors, lunette oakley pas cher, true religion outlet, nike tn pas cher, replica handbags, nike air max uk, longchamp soldes, nike free, longchamp pas cher, north face uk, ralph lauren pas cher, michael kors uk, north face pas cher, vanessa bruno pas cher, true religion outlet, polo ralph lauren uk, nike air force, converse, vans pas cher, nike roshe uk, burberry pas cher, sac guess pas cher, true religion outlet, nike air max uk, ray ban uk, hogan sito ufficiale, jordan pas cher, hermes pas cher, mulberry uk, polo lacoste pas cher, nike free pas cher, abercrombie and fitch UK
BalasHapuschi flat iron, iphone cases, wedding dresses, hollister clothing, reebok outlet, herve leger, converse, mac cosmetics, iphone 6 plus cases, vans outlet, jimmy choo outlet, giuseppe zanotti, timberland boots, ray ban, celine handbags, polo ralph lauren, vans scarpe, iphone 6 cases, ghd hair, beats by dre, oakley, mont blanc, p90x workout, iphone 6s cases, instyler ionic styler, valentino shoes, north face outlet, mcm handbags, abercrombie and fitch, insanity workout, iphone 5s cases, bottega veneta, gucci, nike air max, hollister, iphone 6s plus cases, nike air max, new balance shoes, lululemon outlet, babyliss pro, soccer shoes, north face outlet, ipad cases, asics running shoes, nfl jerseys, s6 cases, nike roshe run, softball bats, soccer jerseys, salvatore ferragamo, hermes handbags, louboutin
BalasHapussac louis vuitton, ugg,uggs,uggs canada, supra shoes, coach outlet, canada goose outlet, doke & gabbana, hollister, montre pas cher, pandora jewelry, swarovski uk, ugg pas cher, canada goose, juicy couture outlet, links of london uk, moncler uk, moncler, louis vuitton, canada goose jackets, louis vuitton uk, thomas sabo uk, barbour, moncler, moncler jackets, lancel, canada goose outlet, ugg,ugg australia,ugg italia, barbour jackets uk, canada goose, replica watches, karen millen uk, moncler, pandora jewelry, juicy couture outlet, swarovski jewelry, canada goose jackets, toms shoes, louis vuitton, marc jacobs, pandora charms, ugg uk, canada goose uk, canada goose pas cher, moncler outlet, bottes ugg pas cher, pandora uk, wedding dresses uk, moncler, moncler pas cher, sac louis vuitton, converse shoes outlet
BalasHapusninest123 12.15
zhengjx20160326
BalasHapusburberry outlet
marc jacobs handbags
cheap ray ban sunglasses
bottega veneta shoes
true religion outlet
fitflops shoes
ray ban sunglasses
christian louboutin shoes
oakley sunglasses
michael kors outlet online
burberry bags
coach outlet online
michael kors handbags
burberry outlet online
air max
ray ban sunglasses
coach factory online
chi flat iron
fitflops
jimmy choo outlet store
instyler max
michael kors handbags
ralph lauren polo shirts
under armour
nike tn pas cher
coach outlet
nike running shoes
gucci borse
nike cortez shoes
stephen curry shoes
coach outlet store
abercrombie & fitch
lacoste shoes
rolex submariner
michael kors outlet online
vans store
kate spade outlet
jimmy choo
michael kors watches
asics gel kayano
oakley sunglasses wholesale
BalasHapustiffany jewelry
lululemon pants
swarovski crystal
ray-ban sunglasses
lululemon uk
ferragamo shoes
ralph lauren polo shirts
babyliss flat iron
coach handbags outlet
oakley sunglasses
ferragamo outlet
swarovski crystal
hollister uk
oakley sunglasses
rolex watches for sale
tiffany jewelry
ralph lauren uk
mulberry handbags sale
tiffany outlet
fitflops sale
cheap oakley sunglasses
louis vuitton handbags
ralph lauren pas cher
ralph lauren uk
true religion outlet
true religion outlet
oakley sunglasses
ray ban sunglasses
michael kors outlet uk
cai20160329
zhengjx20160411
BalasHapusjordan retro 11
true religion jeans
michael kors outlet
nike huarache black
ray ban outlet
insanity workout
louis vuitton outlet
michael kors outlet
ugg boots
pandora jewelry
kobe 10
kobe 8
michael kors outlet
jordan 3 retro
coach outlet
coach outlet online
adidas originals store
nike free uk
ray ban sunglasses uk
christian louboutin outlet
asics shoes for men
kids lebron shoes
michael kors outlet clearance
tory burch shoes
coach outlet store online
coach outlet
coach outlet clearance
louis vuitton purses
ray bans
cheap jordan shoes
nike running shoes for men
burberry handbags
beats by dre outlet
louis vuitton handbags
nike air max uk
retro 11
coach outlet
coach outlet online
nike roshe run mens
cheap oakley sunglasses
chicago blackhawks jerseys
BalasHapuspackers jerseys
cincinnati bengals jersey
chicago bears jersey
chicago bulls jerseys
los angeles lakers jersey
arizona cardinals jerseys
pittsburgh steelers jerseys
denver broncos jersey
nike free running
mizuno running shoes
jaguars jersey
carolina panthers jerseys
cheap nike shoes sale
chicago bulls jersey
seattle seahawks jerseys
golden state warriors jerseys
san francisco 49ers jerseys
philadelphia eagles jersey
giuseppe zanotti outlet
polo pas cher
supra shoes sale
minnesota vikings jersey
hollister
air max 2014
foamposite shoes
los angeles clippers jersey
san diego chargers jerseys
tommy hilfiger
minnesota vikings jerseys
abercrombie outlet
nike trainers uk
steelers jerseys
tods outlet online
linyuan0517
chenlina20160709
BalasHapuscoach factory outlet
coach outlet store online
adidas yeezy
adidas outlet
burberry bags
polo ralph lauren
air jordans
air max 90
oakley sunglasses outlet
coach factory outlet
mont blanc
jordan 11 concord
longchamp outlet
nike roshe flyknit
louis vuitton purses
michael kors outlet
louis vuitton outlet
nike uk
fake watches
cheap nfl jerseys
tiffany outlet
louis vuitton outlet
gucci outlet
louis vuitton
true religion
michael kors handbags
hollister clothing
nike sb
polo ralph lauren outlet
celine bags
louis vuitton outlet
nike air max 90
nike factory outlet
coach factory outlet
ralph lauren outlet
beats solo
michael kors handbags
oakley vault
asics outlet
pandora jewelry
as
true religion jeans outlet
BalasHapusoakley sunglasses outlet
louis vuitton handbags
canada goose sale
moncler uk
coach outlet online
cheap ray bans
michael kors handbags
dolce and gabbana outlet online
jordan pas cher
longchamp outlet store
babyliss hair dryer
nike store uk
ecco outlet
kate spade bags
polo ralph lauren
cheap ray ban sunglasses
chaussure louboutin
ralph lauren uk
timberland uk
tiffany jewelry
michael kors purses
armani outlet
ghd hair dryer
louis vuitton borse
christian louboutin sale
ugg boots outlet
coach outlet online
yeezy boost 750
under armour
adidas superstar white
pandora charms sale clearance
louis vuitton outlet online
20160722caiyan
ray ban sunglasses
BalasHapusjordan 11
uggs canada
louis vuitton bags
polo ralph lauren
louis vuitton handbags
fitflops sale clearance
louis vuitton handbags
rolex watches
hogan scarpe
tory burch flats
instyler curling iron
oakley vault
louis vuitton
coach outlet
washington wizards jerseys
longchamp sac
kevin durant shoes 8
ray ban sunglasses
polo ralph lauren
retro jordans
cheap uggs
polo ralph lauren
giuseppe zanotti
timberland boots
timberland boots
louis vuitton outlet
ray ban sunglasses outlet
new york knicks jerseys
christian louboutin outlet
true religion jeans
michael kors outlet
louis vuitton outlet
giuseppe zanotti sneakers
cartier watches
true religion outlet
coach factory outlet
uggs on sale
ray ban sunglasses uk
20168.15wengdongdong
cheap oakley sunglasses
BalasHapustiffany and co outlet
cheap real jordans
lacoste outlet
adidas superstar
nfl jerseys from china
tiffany jewelry
michael kors outlet
timberland outlet
skechers shoes
nike blazer pas cher
BalasHapusbengals jersey
san antonio spurs
michael kors handbags
salomon shoes
toms shoes
polo ralph lauren outlet
san francisco 49ers jerseys
nike air force 1
michael kors handbags
thanks for sharing it. i really like it. always suckses.
BalasHapusbest regards
RRA
kertas nasi
kemasasn sehat
kemasan foodgrade
karpet raja
distributor karpet
raja karpet masjid
khulafa biotech
Pabrik Sterno
thanks for sharing it. i really like it. always suckses.
BalasHapusbest regards
RRA
kertas Nasi
Kemasasn Sehat
Kemasan Foodgrade
karpet Raja
Distributor Karpet
Raja Karpet Masjid
khulafa Biotech
Pabrik Sterno
Rahma Rizki Abadi
Raja Tempat Sampah
thanks for sharing it. i really like it. always suckses.
BalasHapusbest regards
RRA
kertas Nasi
Kemasasn Sehat
Kemasan Foodgrade
karpet Raja
Distributor Karpet
Raja Karpet Masjid
khulafa Biotech
Pabrik Sterno
Rahma Rizki Abadi
Raja Tempat Sampah
cheap nba jerseys
BalasHapusnew york jets jerseys
hermes belts
nike store uk
michael kors handbags
canada goose
omega watches for sale
fitflops sale clearance
fitflops
bengals jersey
What a great information, maybe i'll share it to my friends :)
BalasHapusplease visit my site!!!
Map Raport, Map Ijazah, Map Sertifikat, buku agenda
Map Raport, Map Raport Murah, Map Raport Jakarta, Map Raport Murah Jakarta
jual online sampul raport jakarta
map ijazah, map ijazah murah, map ijazah jakarta, jual map ijazah murah jakarta
jual online sampul ijazah jakarta
Map Sertifikat, Map Sertifikat Murah, Map Sertifikat Jakarta, map sertifikat murah jakarta
jual map sertifikat murah jakarta
jual online map sertifikat jakarta
Map Raport Murah, Map Raport Jakarta, Map Raport
jasa seo, jasa seo jakarta
Thank You
ray bans
BalasHapuspandora jewelry
ugg outlet
ray ban sunglasses
michael kors outlet
michael kors uk
christian louboutin outlet
replica rolex
miami heat
hollister
Mas minta tolong dong, kirimkan ya full projectnya ke momojomo777@gmail.com, sebelumnya, makasih banyak ya atas perhatianya....
BalasHapusLife time Replacement is something which you scarcely find, while you Buy facebook reviews. Exclusively a few good companies offer up this. buy facebook 5 star reviews
BalasHapusAre you currently looking for valid YouTube subscribers? Forget your headaches, we will thoroughly assist you to buy youtube subscriber
BalasHapusavriq Desktop/Laptop Repair
BalasHapusavriq yellow pages
avriq bbb
avriq business services
www.Avriq.com
avriq India
Observe newest web marketing trends. Buy YouTube subscribers and Compete your competitors. buying youtube subs
BalasHapusrun 3 unblocked
BalasHapusrun 3 unblocked 66
unblocked games run 3
I am glad to see this post. all the details are awesome and good in this post
BalasHapusHyundai Xcent Double Din Player
Tata Nexon Double Din Player
Hyundai Verna
Hypersonic OEM Double Din Player
J3l USB Double Din Player
Double Din DVD Player
car accessories
Hyundai Creta OEM Double Din Player
Hyundai i20 OEM Double Din Player
Hyundai Grand i10 OEM Double Din Player
Movers and packers in mohali
BalasHapusPatrachar Vidyalaya Admission Form
Patrachar Vidyalaya Shalimar Bagh
Open School admission
Cbse Patrachar
visit to our website for Hp printers help
BalasHapusHP Printer customer support number
hp printer customer care number
hp support number
hp service centre USA
hp store contact number
hp service centre near me
HP Printer tech support phone number USA
We are popular as Florist Service in Gurgaon from last 10 Years, we also offers fresh flowers cakes and latest gifts across Gurgaon. Send flowers online and Offline from flower shop for your loved ones and availlable for corporate gifting with fastest delivery.
BalasHapusFlorist Service in Gurgaon
Online Florist Services in Gurgaon
El IWC Ingenieur Chronograph Edition "W 125" viene en una caja de titanio con una esfera plateada que podría pasar fácilmente por blanco. En lugar de los acentos de oro rosa,replicas relojes el Ingenieur Chronograph Edition "W 125" tiene acentos negros que contrastan bruscamente con la esfera blanca plateada. Las impresiones para la escala del taquímetro, así como las marcas para los sub-diales, son todas negras. Las manecillas tipo bastón también son negras y cuentan con material luminiscente generosamente aplicado. El estilo de los marcadores de hora también es similar y están marcados con un punto lume y un marcador de barra negra aplicada. La luz blanca se usa para los marcadores de hora para crear un esquema armonioso de color blanco y negro. La fecha a las 3 en punto presenta una rueda de fecha blanca y fuentes negras para la fecha.replicas rolex Completan el look una correa de cuero negro de piel de becerro de estilo vintage. De los tres modelos, el Ingenieur Chronograph Edition "W 125" es el más legible. Este modelo está limitado a 750 piezas.
BalasHapusUltimo ma non meno importante, abbiamo la Ingenieur Chronograph Edition "Rudolf Caracciola".audemars piguet replica Questo orologio rende omaggio a Rudolf Caracciola, che è stato uno dei migliori piloti del suo tempo. È tre volte vincitore del Campionato europeo piloti con Mercedes-Benz, l'equivalente del Campionato mondiale di Formula 1 di oggi; e anche tre volte vincitore dell'European Hillclimbing Championship;bell and ross replica e ha stabilito numerosi record di velocità durante il suo tempo. Incredibilmente,breitling replica è arrivato primo in 144 delle 204 gare in cui ha partecipato.
BalasHapuscheap jordans
BalasHapuscheap jordans
kd shoes
nike air max 270
off white
retro jordans
yeezy boost 350 v2
christian louboutin outlet
michael kors handbags sale
westbrook shoes
yeezy
BalasHapusbirkin bag
kyrie 6
kawhi leonard shoes
a bathing ape
jordan 11
yeezy shoes
paul george shoes
yeezy
supreme t shirt
kd 12 shoes
BalasHapusadidas yeezy
yeezy
nike off white
supreme hoodie
kyrie irving shoes
curry 8
golden goose sneakers
birkin bag
off white hoodie