[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

excell automation using c++

How can I edit an excell cell (i.e. font size and color) using visual c++ not vb
0
ndenson
Asked:
ndenson
1 Solution
 
obrienslalomCommented:
I'm not really sure what you are trying to do here, but if its possible to use the XML format of the workbook, the task won't be as hard.  Create a sample workbook, save it as a XML document and then open it up in notepad.  You will see the styles are relatively easy to create.
Then i suggest vba, because otherwise things are going to get more complicated.
Otherwise, there are COM objects out there that you can use.  I don't remember the details of them, but I'm pretty sure I used them at one point (likely from .net).  I tried a quick search, which wasn't what i expected.  Maybe they will help:
http://support.microsoft.com/kb/216686
http://support.microsoft.com/kb/308407
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now