Membuat File Excel dengan C#(Sharp)

Kali ini saya akan memberikan contoh untuk membuat file Excel menggunakan C#.Net,
langsung kita mulai saja,,

pertama add reference module excelnya ke program yang kita bikin,kalau bisa satu folder dengan hasilprogram tersebut lalu,
tambahkan Code dibawah ini di paling atas program yang kita buat
using Excel = Microsoft.Office.Interop.Excel;
using System.Runtime.InteropServices;

kemudian buat sebuah fungsi yang di panggil untuk mencetaknya seperti ini contohnya
Private void Cetak()
{
oExcel = new Microsoft.Office.Interop.Excel.Application();
//dua baris dibawah untuk mengubah setingan sementara ketika kita menggunakan settingan //indonesia di komputer kita,sehinggga mengatasi error System.Globalization.CultureInfo oldCI = System.Threading.Thread.CurrentThread.CurrentCulture;
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");

oBook = oExcel.Workbooks.Add(System.Reflection.Missing.Value);
oSheet = (Excel.Worksheet)oBook.ActiveSheet;
oSheet.Name = "Testing";
//untuk memasukkan data ke excel //seperti ini contohnya : oSheet.Cells[row, col] = data;
oSheet.Cells[1, 1] = "Saya Sedang Mencoba Membuat File Excel";
//untuk mengcustom cell-cell yang telah kita buat //ini Contohnya : oRange = oSheet.get_Range(cellFrom, cellUntil);
oRange = oSheet.get_Range(A1,E2);
oRange.MergeCells = true;
oRange.Font.Size = 12;
oRange.Font.Bold = True;
oRange.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
oRange.VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;
oRange.WrapText = true;
oExcel.Visible = true;
oBook.SaveAs("Nama_File_Test.xls", Excel.XlFileFormat.xlWorkbookNormal, null, null, false, false, Excel.XlSaveAsAccessMode.xlShared, false, false, null, null, null);
System.Threading.Thread.CurrentThread.CurrentCulture = oldCI;

}
berikut gambar hasilnya.
silahkan dicoba2 code yg lain jika ingin tampilan yang berbeda,
demikian dulu tutorial dari saya ini,kurang lebihnya saya mohon maaf,,
terimakasih & semoga bermanfaat.

New Deal or Raw Deal?

Editorial Reviews

In this shocking and groundbreaking new book, economic historian Burton W. Folsom exposes the idyllic legend of Franklin D. Roosevelt as a myth of epic proportions. With questionable moral character and a vendetta against the business elite, Roosevelt created New Deal programs marked by inconsistent planning, wasteful spending, and opportunity for political gain -- ultimately elevating public opinion of his administration but falling flat in achieving the economic revitalization that America so desperately needed from the Great Depression. Folsom takes a critical, revisionist look at Roosevelt's presidency, his economic policies, and his personal life.

Elected in 1932 on a buoyant tide of promises to balance the increasingly uncontrollable national budget and reduce the catastrophic unemployment rate, the charismatic thirty-second president not only neglected to pursue those goals, he made dramatic changes to federal programming that directly contradicted his campaign promises. Price fixing, court packing, regressive taxes, and patronism were all hidden inside the alphabet soup of his popular New Deal, putting a financial strain on the already suffering lower classes and discouraging the upper classes from taking business risks that potentially could have jostled national cash flow from dormancy. Many government programs that are widely used today have their seeds in the New Deal. Farm subsidies, minimum wage, and welfare, among others, all stifle economic growth -- encouraging decreased productivity and exacerbating unemployment.

Roosevelt's imperious approach to the presidency changed American politics forever, and as he manipulated public opinion, American citizens became unwitting accomplices to the stilted economic growth of the 1930s. More than sixty years after FDR died in office, we still struggle with the damaging repercussions of his legacy.
See all Editorial Reviews

The Song Is You

A not-quite-young-anymore man, his relationship trouble, and his iPod: at first glance Arthur Phillips's The Song Is You sounds like strictly Nick Hornby territory, but it turns out to be a lot closer to The Red Shoes, a story of love and art in which the two are confused and jealously compete. And as in The Red Shoes, but so rarely in other works of art, it's the art-making that carries the most power and mystery. Julian Donahue is a "creative": a skilled director of commercials who has come to know his limits. ....

Cait O'Dwyer is a singer, and a bit of a comet that Julian somehow catches the tail of. Their courtship--as Julian evades a marriage split by an unbearable loss and Cait shoots single-mindedly toward stardom--is an intricately constructed pas de deux that is both surprising and convincing throughout. It's Phillips's first novel set in the present since Prague, and in its artful structure, style, and heart it's a match for that smart and charming debut. --Tom Nissley

• Read more about The Song Is You
• Read the first chapter

Genesis

If robots began to self-evolve, learning to feel and create as we do, what traits would set humans apart--and help us survive? Beckett isn't the first to dramatize this question, and his Genesis pays subtle homage to his predecessors (including Isaac Asimov, Arthur C. Clarke, and Philip K. Dick). But his near-future tale feels unique, and oddly credible. As the young historian Anax endures an examination by the Academy--an order of philosopher-rulers as imagined in Plato's Republic

--we're brought up quickly on a catastrophic backstory: accelerating climate change, dust storms, rising fear and fundamentalism, the Last War, and the rise of a new Plato, who builds an island republic and seals it behind a Great Sea Fence. Plagues decimate human populations outside, while the Republic's surveillance society (thick with shadows of Huxley, Atwood, and Moore) flourishes under the Orwellian motto "Forward towards the past"--until it falls to forces led by the young rebel Adam Forde. The Academy interrogates Anax on Adam's period of imprisonment with the most advanced android of his time, and we witness their vicious sparring on the virtues of men and machines, the nature of consciousness, and what gives any life worth. It may not sound gripping, but Genesis reads like a thriller to the last word, propelled by the power of ideas longing to be unleashed. --Mari Malcolm

• Read more about Genesis
• Read the first chapter

The Sweetness at the Bottom of the Pie by Alan Bradley

It's the beginning of a lazy summer in 1950 at the sleepy English village of Bishop's Lacey. Up at the great house of Buckshaw, aspiring chemist Flavia de Luce passes the time tinkering in the laboratory she's inherited from her deceased mother and an eccentric great uncle. When Flavia discovers a murdered stranger in the cucumber patch outside her bedroom window early one morning, she decides to leave aside her flasks and Bunsen burners to solve the crime herself, much to the chagrin of the local authorities. But who can blame her? What else does an eleven-year-old science prodigy have to do when left to her own devices? With her widowed father and two older sisters far too preoccupied with their own respective pursuits and passions—stamp collecting, adventure novels, and boys....

—Flavia takes off on her trusty bicycle Gladys to catch a murderer. In Alan Bradley's critically acclaimed debut mystery, The Sweetness at the Bottom of the Pie, adult readers will be totally charmed by this fearless, funny, and unflappable kid sleuth. But don't be fooled: this carefully plotted detective novel (the first in a new series) features plenty of unexpected twists and turns and loads of tasty period detail. As the pages fly by, you'll be rooting for this curious combination of Harriet the Spy and Sherlock Holmes. Go ahead, take a bite. --Lauren Nemroff

• Read more about The Sweetness at the Bottom of the Pie
• Read the first chapter

Liberty and Tyranny

Product Description
Conservative talk radio's fastest-growing superstar is also a New York Times bestselling phenomenon: the author of the groundbreaking critique of the Supreme Court, Men in Black, and the deeply personal dog lover's memoir Rescuing Sprite, Mark R. Levin now delivers the book that characterizes both his devotion to his more than 5 million listeners and his love of our country and the legacy of our Founding Fathers: Liberty and Tyranny is Mark R. Levin's clarion call to conservative America, a new manifesto for the conservative movement for the 21st century.

In the face of the modern liberal assault on Constitution-based values, an attack that has steadily snowballed since President Roosevelt's New Deal of the 1930s and resulted in a federal government that is a massive, unaccountable conglomerate, the time for re-enforcing the intellectual and practical case for conservatism is now. Conservative beliefs in individual freedoms do in the end stand for liberty for all Americans, while liberal dictates lead to the breakdown of civilized society -- in short, tyranny. Looking back to look to the future, Levin writes "conservatism is the antidote to tyranny precisely because its principles are our founding principles." And in a series of powerful essays, Levin lays out how conservatives can counter the liberal corrosion that has filtered into every timely issue affecting our daily lives, from the economy to health care, global warming, immigration, and more -- and illustrates how change, as seen through the conservative lens, is always prudent, and always an enhancement to individual freedom.

As provocative, well-reasoned, robust, and informed as his on-air commentary, Levin's narrative will galvanize readers to begin a new era in conservative thinking and action. Liberty and Tyranny provides a philosophical, historical, and practical framework for revitalizing the conservative vision and ensuring the preservation of American society.

The Day We Lost the H-Bomb

In 1966, a mid-air collision off the coast of Spain between a fueling tanker and a B2 bomber resulted in a loss of life, strained international relations, and a PR nightmare for the US government. Not only had the crash put innocent civilians at risk from raining debris, but it also produced a much larger problem once the dust had cleared: four hydrogen bombs were now unaccounted for. The Day We Lost the H-Bomb...

explores an awakening to the realities of a nuclear age. Despite a handful of plutonium-grade foul-ups on our own soil, Americans were seemingly at ease with a burgeoning arsenal of nuclear weaponry. Cold War anxiety over the ever-reaching arm of Communism fueled massive increases in U.S. military spending, yet not enough attention was given to the dangers of an arms race until this fatal accident abroad. --Dave Callanan

• Read more about The Day We Lost the H-Bomb
• Read the first chapter

IACP Cookbook Awards: 2009 Winners

Editorial Reviews

From Publishers Weekly
Starred Review. One of San Francisco's most popular new restaurants, A16 is devoted to southern Italy's rustic cuisine and robust wines. This book, by its executive chef and wine director, begins by exploring eight grape-growing areas in the south, from the region's heart in Campania to mountainous Abruzzo and the isolated island of Sardinia in the Mediterranean. With a dizzying number of wines produced in each area, the focus is wisely kept on the grapes themselves, with eloquent essays on the history and qualities of both classic and less familiar red and white varietals, and food pairing tips as well as recommendations of wine producers. The second half presents some of those foods—peasant cooking like pasta with chunky,,,

chili-spiked sauce, a rabbit mixed grill and, of course, Neapolitan pizza, with A16's Bay Area location showing in occasional ingredient twists like the tangerines in an arugula salad and the zesty punch of preserved Meyer lemon in a grilled shrimp dish. Executive chef Appleman's expertise is reflected in a chapter on the pig, including recipes for making pancetta and sausages, which are rather advanced for casual home cooks but, like the rest of the book, make fascinating reading for lovers of Italian food and wine. (Sept.)
Copyright © Reed Business Information, a division of Reed Elsevier Inc. All rights reserved.

Product Description
At San Francisco's acclaimed A16 restaurant (named for the highway that cuts across southern Italy), diners pack the house for chef Nate Appleman's house-cured salumi, textbook Naples-style pizzas, and gutsy slow-cooked meat dishes. Wine director Shelley Lindgren is renowned in the business for her expeditionary commitment to handcrafted southern Italian wines. In A16: FOOD + WINE, Appleman and Lindgren share the source of their inspiration--the bold flavors of Campania. From chile-spiked seafood stews and savory roasts to delicate antipasti and vegetable sides, the recipes are beguilingly rustic and approachable. Lindgren's vivid profiles of the key grapes and producers of southern Italy provide vital context for appreciating and pairing the wines. Stunning photography captures the wood-fired ambiance of the restaurant and the Campania countryside it celebrates.