LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default issue with concatonating string exporting to excel through C#

Hello, and thank you in advance for your support.
I am trying to export a string to Excel in my C# program, which contains
multiple font formats. My string is 1/2 static and 1/2 dynamic with the font
formatting in the static portion. I need to have the string display as
follows,
(static)Communities include[superscript](1)[/superscript]: (dynamic)
community1,community2,etc.

The string must be contained in a single cell centered on the report.
I have tried writing the static portion to a single cell in excel, and using
an * after that. Then calling the range.Replace() function. The arguments for
this function are listed as 2 required and the rest optional, but using
Visual C# .NET, my compiler is requiring me to supply every argument, which
then gives me an error in my excel generator.

I have searched for an append function in the excel namespace, but to no
avail. I also tried the excel.WorksheetFunction.Substitute() function, but my
program is requiring 4 arguments: 3 strings, and one object. Every reference
I can find requires only 3 arguments, which confounds me. Any help would be
much appreciated, and once again, thank you for your assistance.

Brandon Schoen
Real Estate Economics
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Non Numeric String Lookup Issue slf Excel Worksheet Functions 3 July 8th 09 09:40 PM
problems with formating and concatonating time [hours] Bret Bernever Excel Worksheet Functions 3 July 6th 08 08:41 PM
Exporting from Access to Excel issue - blank graph view Lisa Setting up and Configuration of Excel 0 March 13th 07 08:05 PM
Exporting chart issue JohnInStockie Charts and Charting in Excel 1 March 12th 07 12:51 PM
Importing/Exporting text files and string editing Slick Willie Excel Programming 1 September 23rd 04 12:24 AM


All times are GMT +1. The time now is 11:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"