作成日: 2017/04/21 最終更新日: 2017/04/21
文書種別
使用方法
詳細
SaveTextFileRange メソッドのオーバーロードで、forceCellDelimiterをTrueに設定することで、セル区切り文字が常に表示されるようになります。
◎サンプルコード(VB)
◎サンプルコード(C#)
◎サンプルコード(VB)
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If IsPostBack Then
Return
End If
' テストデータを設定します
FpSpread1.ActiveSheetView.Cells(0, 0).Value = "a"
FpSpread1.ActiveSheetView.Cells(0, 1).Value = "b"
FpSpread1.ActiveSheetView.Cells(0, 2).Value = "c"
FpSpread1.ActiveSheetView.Cells(1, 0).Value = "d,d"
FpSpread1.ActiveSheetView.Cells(1, 1).Value = "e"
FpSpread1.ActiveSheetView.Cells(1, 2).Value = "f"
End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
' クライアント側の変更を確定
FpSpread1.SaveChanges()
Dim pathname As String = HttpContext.Current.Server.MapPath(Request.ApplicationPath & "/")
' セル区切り文字を必ず出力
FpSpread1.ActiveSheetView.SaveTextFileRange(0, 0, 2, 3, pathname + "test.csv", False, FarPoint.Web.Spread.Model.IncludeHeaders.None, vbCrLf, ",", """", True)
End Sub
If IsPostBack Then
Return
End If
' テストデータを設定します
FpSpread1.ActiveSheetView.Cells(0, 0).Value = "a"
FpSpread1.ActiveSheetView.Cells(0, 1).Value = "b"
FpSpread1.ActiveSheetView.Cells(0, 2).Value = "c"
FpSpread1.ActiveSheetView.Cells(1, 0).Value = "d,d"
FpSpread1.ActiveSheetView.Cells(1, 1).Value = "e"
FpSpread1.ActiveSheetView.Cells(1, 2).Value = "f"
End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
' クライアント側の変更を確定
FpSpread1.SaveChanges()
Dim pathname As String = HttpContext.Current.Server.MapPath(Request.ApplicationPath & "/")
' セル区切り文字を必ず出力
FpSpread1.ActiveSheetView.SaveTextFileRange(0, 0, 2, 3, pathname + "test.csv", False, FarPoint.Web.Spread.Model.IncludeHeaders.None, vbCrLf, ",", """", True)
End Sub
◎サンプルコード(C#)
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
// テストデータを設定します
FpSpread1.ActiveSheetView.Cells[0, 0].Value = "a";
FpSpread1.ActiveSheetView.Cells[0, 1].Value = "b";
FpSpread1.ActiveSheetView.Cells[0, 2].Value = "c";
FpSpread1.ActiveSheetView.Cells[1, 0].Value = "d,d";
FpSpread1.ActiveSheetView.Cells[1, 1].Value = "e";
FpSpread1.ActiveSheetView.Cells[1, 2].Value = "f";
}
protected void Button1_Click(object sender, EventArgs e)
{
// クライアント側の変更を確定
FpSpread1.SaveChanges();
string pathname = HttpContext.Current.Server.MapPath(Request.ApplicationPath + "/");
// セル区切り文字を必ず出力
FpSpread1.ActiveSheetView.SaveTextFileRange(0, 0, 2, 3, pathname + "test.csv", false, FarPoint.Web.Spread.Model.IncludeHeaders.None, "¥r¥n", ",", "¥"", true);
}
{
if (IsPostBack)
{
return;
}
// テストデータを設定します
FpSpread1.ActiveSheetView.Cells[0, 0].Value = "a";
FpSpread1.ActiveSheetView.Cells[0, 1].Value = "b";
FpSpread1.ActiveSheetView.Cells[0, 2].Value = "c";
FpSpread1.ActiveSheetView.Cells[1, 0].Value = "d,d";
FpSpread1.ActiveSheetView.Cells[1, 1].Value = "e";
FpSpread1.ActiveSheetView.Cells[1, 2].Value = "f";
}
protected void Button1_Click(object sender, EventArgs e)
{
// クライアント側の変更を確定
FpSpread1.SaveChanges();
string pathname = HttpContext.Current.Server.MapPath(Request.ApplicationPath + "/");
// セル区切り文字を必ず出力
FpSpread1.ActiveSheetView.SaveTextFileRange(0, 0, 2, 3, pathname + "test.csv", false, FarPoint.Web.Spread.Model.IncludeHeaders.None, "¥r¥n", ",", "¥"", true);
}
旧文書番号
40311