Archive for December, 2011

Ladies ‘n Gentlemen … the Interface

December 31, 2011

Dependency Injection, code decoupling,  Null object, Compose, Predicate, Branch, Interrupt, Thread … the multiples uses of  an interface.
The Interface is a good friend … better keep by your side 😉

source: I, Interface

update: this article is the winner in “Best C# article of November 2011” competition

Technorati tags: Csharp, Interface

10 € = the price of our private data

December 23, 2011

Lately, a mobile operator had a new offer, made this way:
-refuel your mobile account, twice, each one 10€ minimun,
and you give 10€ more

-within some weeks
-use a well know payment operator

further condition required: a payment operator valid subscription of course

the payment operator needs name,surmane,email,credit card … at least

so, these data mean 10€! :O

Excel poisoning #10: fit print area in one page

December 18, 2011

In previous posts we added a new chart to current worksheet, what if we want to print the whole area only in one page ?

myWorksheet.PageSetup.PrintArea = rangeDataAndChart.Address;
myWorksheet.PageSetup.Orientation = XlPageOrientation.xlLandscape;
myWorksheet.PageSetup.Zoom = false;

Thank you to EnricoG for zoom tip. 😉

Technorati tags: Excel, Csharp

Excel poisoning #9: customizing chart programmatically (C#)

December 17, 2011

Customize graph color.

Here is a brief sample, part III:

IOPXLS.Series chartSeries1st = myCharts.SeriesCollection(1) as IOPXLS.Series;
chartSeries1st.Format.Fill.ForeColor.RGB = (int)XlRgbColor.rgbOrange;

This snippet change color for 1st series of data.

Technorati tags: Excel, Csharp

Excel poisoning #8: customizing chart programmatically (C#)

December 11, 2011

Want to change font size to axis’ labels?

Here is a brief sample, part II:

IOPXLS.Axis chartAxisY = myChart.Axes(XlAxisType.xlCategory) as IOPXLS.Axis;
chartAxisY.TickLabels.Font.Size = myChart.ChartTitle.Characters.Font.Size; 

This snippet sets axis label foint size, same as chart title.

Technorati tags: Excel, Csharp