Question

Which is the most efficient way to make a row of text bold in every worksheet in a file?

Answer 1

use VBA

Answer 2

Something like:
Dim sheet As WorkSheet
For Each sheet In ActiveWorkbook.Sheets
sheet.Rows(1).Font.Bold=True
Next sheet

Answer 3

you can do the same from C# code too

Answer 4

Are you being precise when you say "most efficient", or do you just want an easy way to get it done? There's loads of ways you can parse a string.

Answer 5

What do you mean by worksheet? If it's some kind of plain text file, a program or some markup or something, it's simple enough.

You need to be able to define which bits to modify, which will boil down to being able to define some pattern or condition for the computer to work with. It might be simple. If it's only the top lines you need bold, you'd do everything from the start of a worksheet, up until the first newline. You might have do something more sophisticated, see regular expressions, but it's not hard to do what I think you want to do.

I'm not sure what you mean by each worksheet in a file?

Answer 6

look at her previous questions - i guess "spreadsheet" means Excel spreadsheet
in this case "row of text" should mean a row of cells filled with some text
unfortunately guys here rarely specify exactly what they want...
compare with http://stackoverflow.com - that's the way how adults do it :)

Answer 7

sorry, "wroksheet", not "spreadsheet"

Answer 8

Ah, now I understand. Thank you kol. I thought it might have been some kind of markup based, document format or something. I thought 'row of text' meant a line. Nice one for deciphering that for me.

Answer 9

anytime :)

Answer 10

im trying to find the answer to this now but i cant seem to find the answer !