質問編集履歴
7
修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -26,7 +26,7 @@
|
|
|
26
26
|
|
|
27
27
|
if (ShtName == "apple")
|
|
28
28
|
{
|
|
29
|
-
DataRow[] dataRows =
|
|
29
|
+
DataRow[] dataRows = DataBaseDataSet.＊＊＊＊.Select("Name = 'apple'");
|
|
30
30
|
foreach (var row in dataRows)
|
|
31
31
|
{
|
|
32
32
|
xlSheet.Rows[1].Cells[1].Value = row[1].ToString();
|
6
修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -1,5 +1,6 @@
|
|
|
1
1
|
### 前提・実現したいこと
|
|
2
2
|
|
|
3
|
+
|
|
3
4
|
データベース(SQLserver)のレコードをExcelに直接入力させたいのですが上手くいきませんどのようにしたらよいでしょうか。ご教示願いします。
|
|
4
5
|
|
|
5
6
|
|
|
@@ -25,7 +26,7 @@
|
|
|
25
26
|
|
|
26
27
|
if (ShtName == "apple")
|
|
27
28
|
{
|
|
28
|
-
|
|
29
|
+
DataRow[] dataRows = loginManager_DataBaseDataSet.＊＊＊＊.Select("Name = 'apple'");
|
|
29
30
|
foreach (var row in dataRows)
|
|
30
31
|
{
|
|
31
32
|
xlSheet.Rows[1].Cells[1].Value = row[1].ToString();
|
5
修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -25,7 +25,7 @@
|
|
|
25
25
|
|
|
26
26
|
if (ShtName == "apple")
|
|
27
27
|
{
|
|
28
|
-
//DataRow[] dataRows = loginManager_DataBaseDataSet.＊＊＊＊.Select("
|
|
28
|
+
//DataRow[] dataRows = loginManager_DataBaseDataSet.＊＊＊＊.Select("Name = 'apple'");
|
|
29
29
|
foreach (var row in dataRows)
|
|
30
30
|
{
|
|
31
31
|
xlSheet.Rows[1].Cells[1].Value = row[1].ToString();
|
4
修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -26,6 +26,7 @@
|
|
|
26
26
|
if (ShtName == "apple")
|
|
27
27
|
{
|
|
28
28
|
//DataRow[] dataRows = loginManager_DataBaseDataSet.＊＊＊＊.Select("PCName = 'apple'");
|
|
29
|
+
foreach (var row in dataRows)
|
|
29
30
|
{
|
|
30
31
|
xlSheet.Rows[1].Cells[1].Value = row[1].ToString();
|
|
31
32
|
}
|
3
修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -12,7 +12,27 @@
|
|
|
12
12
|
### 該当のソースコード
|
|
13
13
|
|
|
14
14
|
```C#
|
|
15
|
+
// シートを選択する
|
|
16
|
+
xlSheets = xlBook.Worksheets;
|
|
17
|
+
xlSheet = null;
|
|
18
|
+
for (int i = 1; i < xlSheets.Count; i++)
|
|
19
|
+
{
|
|
20
|
+
// iシート目を操作対象に設定する
|
|
21
|
+
xlSheet = xlSheets[i] as Microsoft.Office.Interop.Excel.Worksheet;
|
|
15
22
|
|
|
23
|
+
//シート名取得
|
|
24
|
+
string ShtName = xlSheet.Name;
|
|
25
|
+
|
|
26
|
+
if (ShtName == "apple")
|
|
27
|
+
{
|
|
28
|
+
//DataRow[] dataRows = loginManager_DataBaseDataSet.＊＊＊＊.Select("PCName = 'apple'");
|
|
29
|
+
{
|
|
30
|
+
xlSheet.Rows[1].Cells[1].Value = row[1].ToString();
|
|
31
|
+
}
|
|
32
|
+
}
|
|
33
|
+
}
|
|
34
|
+
xlApp.Visible = true;
|
|
35
|
+
|
|
16
36
|
```
|
|
17
37
|
|
|
18
38
|
### 試したこと
|
2
修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -12,30 +12,7 @@
|
|
|
12
12
|
### 該当のソースコード
|
|
13
13
|
|
|
14
14
|
```C#
|
|
15
|
-
// シートを選択する
|
|
16
|
-
xlSheets = xlBook.Worksheets;
|
|
17
|
-
xlSheet = null;
|
|
18
|
-
for (int i = 1; i < xlSheets.Count; i++)
|
|
19
|
-
{
|
|
20
|
-
// iシート目を操作対象に設定する
|
|
21
|
-
xlSheet = xlSheets[i] as Microsoft.Office.Interop.Excel.Worksheet;
|
|
22
15
|
|
|
23
|
-
//xlSheet.Rows[0].Cells[0].Value = "";
|
|
24
|
-
//シート名取得
|
|
25
|
-
string ShtName = xlSheet.Name;
|
|
26
|
-
|
|
27
|
-
if (ShtName == "apple")
|
|
28
|
-
{
|
|
29
|
-
//DataRow[] dataRows = loginManager_DataBaseDataSet.DB_V_ALLHISTORY.Select("PCName = 'apple'");
|
|
30
|
-
{
|
|
31
|
-
xlSheet.Rows[1].Cells[1].Value = row[1].ToString();
|
|
32
|
-
|
|
33
|
-
|
|
34
|
-
}
|
|
35
|
-
}
|
|
36
|
-
}
|
|
37
|
-
xlApp.Visible = true;
|
|
38
|
-
|
|
39
16
|
```
|
|
40
17
|
|
|
41
18
|
### 試したこと
|
1
修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -16,17 +16,17 @@
|
|
|
16
16
|
xlSheets = xlBook.Worksheets;
|
|
17
17
|
xlSheet = null;
|
|
18
18
|
for (int i = 1; i < xlSheets.Count; i++)
|
|
19
|
-
|
|
19
|
+
{
|
|
20
|
-
|
|
20
|
+
// iシート目を操作対象に設定する
|
|
21
|
-
|
|
21
|
+
xlSheet = xlSheets[i] as Microsoft.Office.Interop.Excel.Worksheet;
|
|
22
22
|
|
|
23
23
|
//xlSheet.Rows[0].Cells[0].Value = "";
|
|
24
24
|
//シート名取得
|
|
25
25
|
string ShtName = xlSheet.Name;
|
|
26
26
|
|
|
27
|
-
if (ShtName == "
|
|
27
|
+
if (ShtName == "apple")
|
|
28
28
|
{
|
|
29
|
-
//DataRow[] dataRows = loginManager_DataBaseDataSet.DB_V_ALLHISTORY.Select("PCName = '
|
|
29
|
+
//DataRow[] dataRows = loginManager_DataBaseDataSet.DB_V_ALLHISTORY.Select("PCName = 'apple'");
|
|
30
30
|
{
|
|
31
31
|
xlSheet.Rows[1].Cells[1].Value = row[1].ToString();
|
|
32
32
|
|