Tag Archives: Office

Save several images into Access in C#

Posted on May 12, 2017 by Rod Stephens

The example Save images in an Access database in C# includes an Access database. Unfortunately if you save several images into the database and then open the database in Access, Access removes the images. It just doesn’t seem to understand … Continue reading →

Posted in database, graphics, image processing, Office | Tagged Access, C#, C# programming, database, example, example program, graphics, image, image file, image processing, initialize list, list, ListBox, Microsoft Access, Office, picture, save images, save several images, Windows Forms programming | 1 Comment

Load images from an Access database in C#

Posted on May 10, 2017 by Rod Stephens

The post Save images in an Access database in C# explains how to save images in an Access database. This post explains how to load images from an Access display them. Like previous examples, this program uses a SQL statement … Continue reading →

Save images in an Access database in C#

Posted on May 9, 2017 by Rod Stephens

This example shows how you can save images in an Access database. The example Use filenames stored in a database to display images in C# shows how to display images by saving the image file names in a database and … Continue reading →

Convert RTF and TXT files into DOCX files in C#

Posted on January 19, 2017 by Rod Stephens

First add a reference to Microsoft.Office.Interop.Word. To make using the library easier, add this using statement: using Word = Microsoft.Office.Interop.Word; When you enter the input and output file names and click Convert, the program uses the following code to open … Continue reading →

Posted in files, interoperability, Office, Word | Tagged C#, C# programming, DOCX, example, example program, files, interoperability, Microsoft Office, Microsoft Word, Office, RTF, TXT, Windows Forms programming, Word | Leave a comment

Convert doc files into docx files in C#

Posted on November 17, 2016 by Rod Stephens

This example shows how to write a C# program to automatically convert doc files into docx files. In a previous version of Windows, whenever I double-clicked a .doc file, I got this error message: Error The operating system is not … Continue reading →

Posted in Office, Word | Tagged C#, C# programming, convert doc files, convert docx files, doc to docx, example, example program, Microsoft Word, Microsoft Word 2007, Office, Windows Forms programming, Word, Word 2007 | Leave a comment

Load a CSV file in Excel in C#

Posted on August 3, 2016 by Rod Stephens

Loading a CSV file (comma-separated value file) into Excel isn’t too hard once you know the tricks. Using the same tricks you can load a file that uses any delimiter, not just a comma. First at design time, add a … Continue reading →

Posted in Excel, files, Office | Tagged C#, C# programming, comma-separated-value file, CSV, csv file, example, example program, Excel, load comma-separated value file, load CSV, load CSV file, Office, Windows Forms programming | 5 Comments

Make an Excel chart in C#

Posted on February 24, 2016 by Rod Stephens

This example uses the following code to create an Excel chart in a new workbook. private void btnCreateChart_Click( object sender, EventArgs e) { // Get the Excel application object. Excel.Application excel_app = new Excel.ApplicationClass(); // Make Excel visible (optional). excel_app.Visible … Continue reading →

Posted in Excel, interoperability, Office | Tagged C#, C# programming, chart, example, example program, Excel, Excel chart, Excel graph, interoperability, Office, Windows Forms programming | Leave a comment

Add and remove pictures in an Excel worksheet

Posted on November 24, 2015 by Rod Stephens

This is another brief foray into VBA programming. When you click the Insert Image button, the following VBA code executes. ‘ Insert a picture at the selection. Sub Button1_Click() Dim filters As String Dim filename As Variant ‘ Define the … Continue reading →

Posted in Excel, Office, VBA | Tagged example, example program, Excel, insert picture, Microsoft Office, Office, remove picture, VBA, Visual Basic for Applications, Windows Forms programming | Leave a comment

Save images in an Access database in WPF and C#

Posted on August 3, 2015 by RodStephens

The example Display images in an Access database in WPF and C# shows how you can display images saved in an Access database. Of course that begs the question, “How do you save images in the database in the first … Continue reading →

Posted in database, graphics, image processing, Office | Tagged C#, C# programming, database, display Access images, display images, example, example program, graphics, image processing, Office, OleDbCommand, OleDbConnection, save Access images, save images, save images in Access, Windows Forms programming | Leave a comment

Display images in an Access database in WPF and C#

Posted on July 31, 2015 by RodStephens

This example shows how you can display images stored in an Access database in a WPF program. You can do this with bound controls, but I find this approach less confusing because you do everything explicitly in code. When the … Continue reading →