Christian - May 2007 Entries

Posts: 337
Comments: 125
Trackbacks: 5

May 2007 Entries

Formeln in Aspose.Cells eingeben: Formeln in Aspose.Cells eingeben ist ziemlich einfach, Z.B.: "=SUMME(E5:E8)" oder "=AVERAGE(E5:E8)"; posted @ Tuesday, May 29, 2007 7:55 AM | Feedback (0)

Die in Excel möglichen Farben in RGB-Werten

Für's Archiv: Die in Excel möglichen Farben in RGB-Werten:

interior	font	*HTML*	bgcolor=	*Red*	Green	Blue	Color
Black	[Color 1]	#000000	#000000	0	0	0	[Black]
White	[Color 2]	#FFFFFF	#FFFFFF	255	255	255	[White]
Red	[Color 3]	#FF0000	#FF0000	255	0	0	[Red]
Green	[Color 4]	#00FF00	#00FF00	0	255	0	[Green]
Blue	[Color 5]	#0000FF	#0000FF	0	0	255	[Blue]
Yellow	[Color 6]	#FFFF00	#FFFF00	255	255	0	[Yellow]
Magenta	[Color 7]	#FF00FF	#FF00FF	255	0	255	[Magenta]
Cyan	[Color 8]	#00FFFF	#00FFFF	0	255	255	[Cyan]
[Color 9]	[Color 9]	#800000	#800000	128	0	0	[Color 9]
[Color 10]	[Color 10]	#008000	#008000	0	128	0	[Color 10]
[Color 11]	[Color 11]	#000080	#000080	0	0	128	[Color 11]
[Color 12]	[Color 12]	#808000	#808000	128	128	0	[Color 12]
[Color 13]	[Color 13]	#800080	#800080	128	0	128	[Color 13]
[Color 14]	[Color 14]	#008080	#008080	0	128	128	[Color 14]
[Color 15]	[Color 15]	#C0C0C0	#C0C0C0	192	192	192	[Color 15]
[Color 16]	[Color 16]	#808080	#808080	128	128	128	[Color 16]
[Color 17]	[Color 17]	#9999FF	#9999FF	153	153	255	[Color 17]
[Color 18]	[Color 18]	#993366	#993366	153	51	102	[Color 18]
[Color 19]	[Color 19]	#FFFFCC	#FFFFCC	255	255	204	[Color 19]
[Color 20]	[Color 20]	#CCFFFF	#CCFFFF	204	255	255	[Color 20]
[Color 21]	[Color 21]	#660066	#660066	102	0	102	[Color 21]
[Color 22]	[Color 22]	#FF8080	#FF8080	255	128	128	[Color 22]
[Color 23]	[Color 23]	#0066CC	#0066CC	0	102	204	[Color 23]
[Color 24]	[Color 24]	#CCCCFF	#CCCCFF	204	204	255	[Color 24]
[Color 25]	[Color 25]	#000080	#000080	0	0	128	[Color 25]
[Color 26]	[Color 26]	#FF00FF	#FF00FF	255	0	255	[Color 26]
[Color 27]	[Color 27]	#FFFF00	#FFFF00	255	255	0	[Color 27]
[Color 28]	[Color 28]	#00FFFF	#00FFFF	0	255	255	[Color 28]
[Color 29]	[Color 29]	#800080	#800080	128	0	128	[Color 29]
[Color 30]	[Color 30]	#800000	#800000	128	0	0	[Color 30]
[Color 31]	[Color 31]	#008080	#008080	0	128	128	[Color 31]
[Color 32]	[Color 32]	#0000FF	#0000FF	0	0	255	[Color 32]
[Color 33]	[Color 33]	#00CCFF	#00CCFF	0	204	255	[Color 33]
[Color 34]	[Color 34]	#CCFFFF	#CCFFFF	204	255	255	[Color 34]
[Color 35]	[Color 35]	#CCFFCC	#CCFFCC	204	255	204	[Color 35]
[Color 36]	[Color 36]	#FFFF99	#FFFF99	255	255	153	[Color 36]
[Color 37]	[Color 37]	#99CCFF	#99CCFF	153	204	255	[Color 37]
[Color 38]	[Color 38]	#FF99CC	#FF99CC	255	153	204	[Color 38]
[Color 39]	[Color 39]	#CC99FF	#CC99FF	204	153	255	[Color 39]
[Color 40]	[Color 40]	#FFCC99	#FFCC99	255	204	153	[Color 40]
[Color 41]	[Color 41]	#3366FF	#3366FF	51	102	255	[Color 41]
[Color 42]	[Color 42]	#33CCCC	#33CCCC	51	204	204	[Color 42]
[Color 43]	[Color 43]	#99CC00	#99CC00	153	204	0	[Color 43]
[Color 44]	[Color 44]	#FFCC00	#FFCC00	255	204	0	[Color 44]
[Color 45]	[Color 45]	#FF9900	#FF9900	255	153	0	[Color 45]
[Color 46]	[Color 46]	#FF6600	#FF6600	255	102	0	[Color 46]
[Color 47]	[Color 47]	#666699	#666699	102	102	153	[Color 47]
[Color 48]	[Color 48]	#969696	#969696	150	150	150	[Color 48]
[Color 49]	[Color 49]	#003366	#003366	0	51	102	[Color 49]
[Color 50]	[Color 50]	#339966	#339966	51	153	102	[Color 50]
[Color 51]	[Color 51]	#003300	#003300	0	51	0	[Color 51]
[Color 52]	[Color 52]	#333300	#333300	51	51	0	[Color 52]
[Color 53]	[Color 53]	#993300	#993300	153	51	0	[Color 53]
[Color 54]	[Color 54]	#993366	#993366	153	51	102	[Color 54]
[Color 55]	[Color 55]	#333399	#333399	51	51	153	[Color 55]
[Color 56]	[Color 56]	#333333	#333333	51	51	51	[Color 56]

Kopiert von: http://www.mvps.org/dmcritchie/excel/colors.htm

posted @ Friday, May 25, 2007 5:31 PM | Feedback (0)

Prüfen ob eine Tabelle in der Datenbank existiert: Fürs Archiv: Prüfen ob eine Tabelle exisitiert:

IF
EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'
AND TABLE_NAME=TabellenName)
-- do something; posted @ Wednesday, May 23, 2007 10:47 AM | Feedback (0)

Hintergrundfarben für Excel in Aspose

Aspose.Cells erstellt eine Excel-Datei im Format Excel 2003. Deshalb lassen sich als Hintergrundfarben nur diejenigen aus Excel 2003 verwenden - das sind insgesamt 56 Farben.

Hier ein Klasse dafür:

public class ExcelColors {
   public static readonly Color Black      = Color.FromArgb( 0, 0, 0 );
   public static readonly Color White      = Color.FromArgb( 255, 255, 255 );
   public static readonly Color Red        = Color.FromArgb( 255, 0, 0 );
   public static readonly Color Lime       = Color.FromArgb( 0, 255, 0 );
   public static readonly Color Blue       = Color.FromArgb( 0, 0, 255 );
   public static readonly Color Yellow     = Color.FromArgb( 255, 255, 0 );
   public static readonly Color Magenta    = Color.FromArgb( 255, 0, 255 );
   public static readonly Color Cyan       = Color.FromArgb( 0, 255, 255 );
   public static readonly Color Maroon     = Color.FromArgb( 128, 0, 0 );
   public static readonly Color Green      = Color.FromArgb( 0, 128, 0 );
   public static readonly Color Navy       = Color.FromArgb( 0, 0, 128 );
   public static readonly Color Olive      = Color.FromArgb( 128, 128, 0 );
   public static readonly Color Purple     = Color.FromArgb( 128, 0, 128 );
   public static readonly Color Teal       = Color.FromArgb( 0, 128, 128 );
   public static readonly Color Silver     = Color.FromArgb( 192, 192, 192 );
   public static readonly Color Gray       = Color.FromArgb( 128, 128, 128 );
   public static readonly Color Color17    = Color.FromArgb( 153, 153, 255 );
   public static readonly Color Color18    = Color.FromArgb( 153, 51, 102 );
   public static readonly Color Color19    = Color.FromArgb( 255, 255, 204 );
   public static readonly Color Color20    = Color.FromArgb( 204, 255, 255 );
   public static readonly Color Color21    = Color.FromArgb( 102, 0, 102 );
   public static readonly Color Color22    = Color.FromArgb( 255, 128, 128 );
   public static readonly Color Color23    = Color.FromArgb( 0, 102, 204 );
   public static readonly Color Color24    = Color.FromArgb( 204, 204, 255 );
   public static readonly Color Color25    = Color.FromArgb( 0, 0, 128 );
   public static readonly Color Color26    = Color.FromArgb( 255, 0, 255 );
   public static readonly Color Color27    = Color.FromArgb( 255, 255, 0 );
   public static readonly Color Color28    = Color.FromArgb( 0, 255, 255 );
   public static readonly Color Color29    = Color.FromArgb( 128, 0, 128 );
   public static readonly Color Color30    = Color.FromArgb( 128, 0, 0 );
   public static readonly Color Color31    = Color.FromArgb( 0, 128, 128 );
   public static readonly Color Color32    = Color.FromArgb( 0, 0, 255 );
   public static readonly Color Color33    = Color.FromArgb( 0, 204, 255 );
   public static readonly Color Color34    = Color.FromArgb( 204, 255, 255 );
   public static readonly Color Color35    = Color.FromArgb( 204, 255, 204 );
   public static readonly Color Color36    = Color.FromArgb( 255, 255, 153 );
   public static readonly Color Color37    = Color.FromArgb( 153, 204, 255 );
   public static readonly Color Color38    = Color.FromArgb( 255, 153, 204 );
   public static readonly Color Color39    = Color.FromArgb( 204, 153, 255 );
   public static readonly Color Color40    = Color.FromArgb( 255, 204, 153 );
   public static readonly Color Color41    = Color.FromArgb( 51, 102, 255 );
   public static readonly Color Color42    = Color.FromArgb( 51, 204, 204 );
   public static readonly Color Color43    = Color.FromArgb( 153, 204, 0 );
   public static readonly Color Color44    = Color.FromArgb( 255, 204, 0 );
   public static readonly Color Color45    = Color.FromArgb( 255, 153, 0 );
   public static readonly Color Color46    = Color.FromArgb( 255, 102, 0 );
   public static readonly Color Color47    = Color.FromArgb( 102, 102, 153 );
   public static readonly Color Color48    = Color.FromArgb( 150, 150, 150 );
   public static readonly Color Color49    = Color.FromArgb( 0, 51, 102 );
   public static readonly Color Color50    = Color.FromArgb( 51, 153, 102 );
   public static readonly Color Color51    = Color.FromArgb( 0, 51, 0 );
   public static readonly Color Color52    = Color.FromArgb( 51, 51, 0 );
   public static readonly Color Color53    = Color.FromArgb( 153, 51, 0 );
   public static readonly Color Color54    = Color.FromArgb( 153, 51, 102 );
   public static readonly Color Color55    = Color.FromArgb( 51, 51, 153 );
   public static readonly Color Color56    = Color.FromArgb( 51, 51, 51 );
}

http://www.aspose.com/Products/Aspose.Cells/Api/index.html?url=http://www.aspose.com/Products/Aspose.Cells/Api/Aspose.Cells.Workbook.ChangePalette.html

Eine farbliche Darstellung der Farben findet man unter:
http://www.mvps.org/dmcritchie/excel/colors.htm

posted @ Wednesday, May 23, 2007 7:30 AM | Feedback (1)

Update mit "Case when"

habe ich ich kürzlich gebraucht - Update mit "Case when":

UPDATE Tabelle SET Feld = CASE
WHEN AnderesFeld ='B' THEN 1
ELSE 0
END

posted @ Friday, May 18, 2007 12:38 PM | Feedback (0)

ASPOSE: Komponente für die Erstellung von Office-Dokumenten

Unter der Adresse http://www.aspose.com kann man sich eine Textversion von Aspose herunterladen. Mit dieser Komponente lassen sich Excel- und Word-Dateien erstellen.

Die Testversion enthällt viele Beispiele, welche die Funktionen erklären.

posted @ Monday, May 14, 2007 7:27 AM | Feedback (0)

SQL-Abfragen mit "OVER"

Mit T-SQL lässt sich von einer Select-Abfrage nur eine Teilmenge der Ergebnisse zurückgeben, so z.B. nur die ersten 10 oder die zweiten 20 Treffer einer SQL-Abfrage.

Dies ist z.B. für die Realisierung einer Paging-Funktionen ideal. Hier ein Beispiel:

WITH Result AS
(SELECT *,ROW_NUMBER()
OVER (ORDER BY [Tabelle].[Feld1]) AS RowNumber
FROM [Tabelle]
)
SELECT * FROM Result WHERE RowNumber>=0 AND RowNumber<=20

In einer .Net Umgebung kann man natürlich den Wert von Rownumber mit AddParam() an den SELECT-Befehl übergeben.

posted @ Saturday, May 12, 2007 2:51 PM | Feedback (2)

Archives

Post Categories

test