Respectable Members
I am beginner in vb.net 2005. Now i am doing a project that is to export all the data to excel sheet programmatically using vb.net 2005. I know how to export the data to excel in a simple manner. That i can only export the data in the Dataset. But i don't know how to populate the excel sheet like
1.Bold the Column header and give background color and change the font styles and give fore color such that.
2.Change the column data types like General, Text, Number such that
3.Fix the Column and row width and height and give back color to particular row or columns
and also i would like to know that any reference books for developing projects like office using vb.net 2005
Can any one help me
Thank you
My email is [email protected]