// JSON にワークブックをシリアル化するときにスタイルと数式を無視します
string jsonWithOption = workbook.ToJson(new SerializationOptions() { IgnoreFormula = true, IgnoreStyle = true });

workbook.FromJson(jsonWithOption);

// xlsx ファイルに保存します
workbook.Save("tojsonwithoptions.xlsx");

// JSON からワークブックを逆シリアル化するときにスタイルと数式を無視します
workbook.FromJson(json, new DeserializationOptions() { IgnoreFormula = true, IgnoreStyle = true });

// xlsx ファイルに保存します
workbook.Save("fromjsonwithoptions.xlsx");

var book = new Workbook();
IWorksheet worksheet = book.Worksheets[0];
// カスタム名スタイルを追加します
IStyle style = book.Styles.Add("testStyle1");
 
style.Font.ThemeColor = ThemeColor.Accent1;
style.Font.TintAndShade = 0.8;
style.Font.Italic = true;
style.Font.Bold = true; 
style.Font.Name = "LiSu";
style.Font.Size = 28;
style.Font.Strikethrough = true;
style.Font.Subscript = true;
style.Font.Superscript = false;
style.Font.Underline = UnderlineType.Double;
 
object[,] data = new object[,]{
    {"test", "test", "test", "test" },
    {"test", "test", "test", "test" },
    {"test", "test", "test", "test" },
    {"test", "test", "test", "test" },
    {"test", "test", "test", "test" },
};
 
worksheet.Range["B2:E6"].Value = data;
worksheet.Range["A:XFD"].Style = book.Styles["testStyle1"];
worksheet.Range["A:XFD"].ColumnWidth = 20;
    
// 使用範囲のみのサイズとスタイルを JSON にエクスポートします
using FileStream jsonFile = new FileStream("TestJson_true.json", FileMode.Create);
book.ToJson(jsonFile, new SerializationOptions() { IgnoreColumnRowInfoOutOfUsedRange = true }); //出力ファイルのサイズは9KBです
    
// すべてのサイズとスタイルを JSON にエクスポートします
using FileStream jsonFile2 = new FileStream("TestJson_false.json", FileMode.Create);
book.ToJson(jsonFile2, new SerializationOptions() { IgnoreColumnRowInfoOutOfUsedRange = false }); //出力ファイルのサイズは793KBです
    
// デフォルトの動作（true オプションと同じ）
book.ToJson(new FileStream("TestJson_default.json", FileMode.Create)); //出力ファイルのサイズは9KBです

// 新しいワークブックを作成します
var workbook = new GrapeCity.Documents.Excel.Workbook();

// 反復計算のオプションを設定します
workbook.Options.Formulas.EnableIterativeCalculation = true;
workbook.Options.Formulas.MaximumIterations = 20;
var worksheet = workbook.Worksheets[0];

// 値と計算式を設定します
worksheet.Range["B2"].Value = "Initial Cash";
worksheet.Range["C2"].Value = 10000;
worksheet.Range["B3"].Value = "Interest";
worksheet.Range["C3"].Value = 0.0125;

worksheet.Range["B5"].Value = "Month";
worksheet.Range["C5"].Value = "Total Cash";

worksheet.Range["B6:B17"].Value = new double[] { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 };

worksheet.Range["C6"].Formula = "=C2*(1+$C$3)";
worksheet.Range["C7:C17"].Formula = "=C6*(1+$C$3)";

// SerializationOptions を初期化し、ExportSharedFormula を true に設定します
SerializationOptions options = new SerializationOptions();
options.ExportSharedFormula = true;

// JSON ファイルを保存します
workbook.ToJson(File.Create("ExportSharedFormulas.json"), options);

// SerializationOptions を初期化し、ExportSharedFormula を false に設定します
SerializationOptions options2 = new SerializationOptions();
options2.ExportSharedFormula = false;

// JSON ファイルを保存します
workbook.ToJson(File.Create("ExportIndividualFormulas.json"), options2);

    //ワークブックを初期化します
    var workbook = new GrapeCity.Documents.Excel.Workbook();
    IWorksheet worksheet = workbook.Worksheets[0];

    CheckBoxListCellType cellType = new CheckBoxListCellType
    {
        Direction = CellTypeDirection.Horizontal,
        TextAlign = CellTypeTextAlign.Right,
        IsFlowLayout = false,
        MaxColumnCount = 2,
        MaxRowCount = 1,
        HorizontalSpacing = 20,
        VerticalSpacing = 5,
    };
    cellType.Items.Add(new SelectFieldItem("sample1", "1"));
    cellType.Items.Add(new SelectFieldItem("sample2", "2"));
    cellType.Items.Add(new SelectFieldItem("sample3", "3"));
    cellType.Items.Add(new SelectFieldItem("sample4", "4"));
    cellType.Items.Add(new SelectFieldItem("sample5", "5"));
    worksheet.Range["A1"].RowHeight = 60;
    worksheet.Range["A1"].ColumnWidth = 25;
    worksheet.Range["A1"].CellType = cellType;

    //チェックボックス型リストでオプションを複数選択します
    worksheet.Range["A1"].Value = new object[,]
   {
{new object[]{"1", "3", "5" } }
   };

    //PDFファイルに保存します
    workbook.Save("addcheckboxlistcelltype.pdf");

//新しいワークブックを作成します
var workbook = new GrapeCity.Documents.Excel.Workbook();

GrapeCity.Documents.Excel.Workbook.ValueJsonSerializer = new CustomObjectJsonSerializer();
IWorksheet worksheet = workbook.Worksheets[0];

CheckBoxListCellType cellType = new CheckBoxListCellType
{
    Direction = CellTypeDirection.Horizontal,
    TextAlign = CellTypeTextAlign.Right,
    IsFlowLayout = false,
    MaxColumnCount = 2,
    MaxRowCount = 1,
    HorizontalSpacing = 20,
    VerticalSpacing = 5,
};
cellType.Items.Add(new SelectFieldItem("player1", new People { Name = "Tom", Age = 5 }));
cellType.Items.Add(new SelectFieldItem("player2", new People { Name = "Jerry", Age = 3 }));
cellType.Items.Add(new SelectFieldItem("player3", new People { Name = "Mario", Age = 6 }));
cellType.Items.Add(new SelectFieldItem("player4", new People { Name = "Luigi", Age = 4 }));
worksheet.Range["A1"].RowHeight = 60;
worksheet.Range["A1"].ColumnWidth = 25;
worksheet.Range["A1"].CellType = cellType;

worksheet.Range["A1"].Value = new object[,]
{
{new object[]{ new People { Name = "Tom", Age = 5 }, new People { Name = "Mario", Age = 6 }} }
};

//PDFファイルに保存します
workbook.Save("addcheckboxlistcelltypecustomobject.pdf");
}
class CustomObjectJsonSerializer : IJsonSerializer
{
    public object Deserialize(string json)
    {
        return Newtonsoft.Json.JsonConvert.DeserializeObject<People>(json);
    }

    public string Serialize(object value)
    {
        if (value is People)
        {
            return Newtonsoft.Json.JsonConvert.SerializeObject(value);
        }
        return null;
    }
}
class People
{
    private int age;
    private string name;

    public int Age { get => age; set => age = value; }
    public string Name { get => name; set => name = value; }

    public override bool Equals(object obj)
    {
        return obj is People people &&
               age == people.age &&
               name == people.name;
    }

    public override int GetHashCode()
    {
        return age.GetHashCode() ^ name.GetHashCode();
    }
}

 //ワークブックを初期化します
 var workbook = new GrapeCity.Documents.Excel.Workbook();
 IWorksheet worksheet = workbook.Worksheets[0];

 RadioButtonListCellType cellType = new RadioButtonListCellType
 {
     Direction = CellTypeDirection.Horizontal,
     TextAlign = CellTypeTextAlign.Right,
     IsFlowLayout = false,
     MaxColumnCount = 2,
     MaxRowCount = 1,
     HorizontalSpacing = 20,
     VerticalSpacing = 5,
 };
 cellType.Items.Add(new SelectFieldItem("sample1", "1"));
 cellType.Items.Add(new SelectFieldItem("sample2", "2"));
 cellType.Items.Add(new SelectFieldItem("sample3", "3"));
 cellType.Items.Add(new SelectFieldItem("sample4", "4"));
 cellType.Items.Add(new SelectFieldItem("sample5", "5"));
 worksheet.Range["A1"].RowHeight = 60;
 worksheet.Range["A1"].ColumnWidth = 25;
 worksheet.Range["A1"].CellType = cellType;
 worksheet.Range["A1"].Value = 1;

 //ラジオボタン型リストでオプションを複数選択します
 worksheet.Range["A1"].Value = new object[,]
{
 {new object[]{"1", "3", "5" } }
};

 //PDFファイルに保存します
 workbook.Save("addradiobuttonlistcelltype.pdf");

//新しいワークブックを作成します
var workbook = new GrapeCity.Documents.Excel.Workbook();


GrapeCity.Documents.Excel.Workbook.ValueJsonSerializer = new CustomObjectJsonSerializer();
IWorksheet worksheet = workbook.Worksheets[0];

RadioButtonListCellType cellType = new RadioButtonListCellType
{
    Direction = CellTypeDirection.Horizontal,
    TextAlign = CellTypeTextAlign.Right,
    IsFlowLayout = false,
    MaxColumnCount = 2,
    MaxRowCount = 1,
    HorizontalSpacing = 20,
    VerticalSpacing = 5,
};
cellType.Items.Add(new SelectFieldItem("player1", new People { Name = "Tom", Age = 5 }));
cellType.Items.Add(new SelectFieldItem("player2", new People { Name = "Jerry", Age = 3 }));
cellType.Items.Add(new SelectFieldItem("player3", new People { Name = "Mario", Age = 6 }));
cellType.Items.Add(new SelectFieldItem("player4", new People { Name = "Luigi", Age = 4 }));
worksheet.Range["A1"].RowHeight = 60;
worksheet.Range["A1"].ColumnWidth = 25;
worksheet.Range["A1"].CellType = cellType;

worksheet.Range["A1"].Value = new object[,]
{
{new People { Name = "Tom", Age = 5 } }
};

//PDFファイルに保存します
workbook.Save("addradiobuttoncelltypecustomobject.pdf");
}

class CustomObjectJsonSerializer : IJsonSerializer
{
    public object Deserialize(string json)
    {
        return Newtonsoft.Json.JsonConvert.DeserializeObject<People>(json);
    }

    public string Serialize(object value)
    {
        if (value is People)
        {
            return Newtonsoft.Json.JsonConvert.SerializeObject(value);
        }
        return null;
    }
}
class People
{
    private int age;
    private string name;

    public int Age { get => age; set => age = value; }
    public string Name { get => name; set => name = value; }

    public override bool Equals(object obj)
    {
        return obj is People people &&
            age == people.age &&
            name == people.name;
    }

    public override int GetHashCode()
    {
        return age.GetHashCode() ^ name.GetHashCode();
    }
}

//ワークブックを初期化します
Workbook workbook = new Workbook();
//シートを取得します
IWorksheet worksheet = workbook.Worksheets[0];
//行の高さを設定します
worksheet.Range["A:A"].RowHeight = 40;
//列幅を設定します
worksheet.Range["A:A"].ColumnWidth = 25;
//ウォーターマークを設定します
worksheet.Range["A1"].Watermark = "GcExcel JAVA";
//セルパディングを設定します
worksheet.Range["A1"].CellPadding = new CellPadding(50, 0, 0, 0);
//ラベルオプションを設定します
worksheet.Range["A1"].LabelOptions.Visibility = LabelVisibility.visible;
worksheet.Range["A1"].LabelOptions.ForeColor = Color.Green;
worksheet.Range["A1"].LabelOptions.Margin = new Margin(15, 0, 0, 0);
worksheet.Range["A1"].LabelOptions.Font.Size = 14;
worksheet.Range["A1"].LabelOptions.Font.Name = "Calibri";
worksheet.Range["A1"].Borders.LineStyle = BorderLineStyle.Thin;

//PDFファイルに保存します
workbook.Save("CellPaddingAndLabels.pdf");

//NumbersFitModeを「Overflow」に設定します
workbook.BookView.NumbersFitMode = GrapeCity.Documents.Excel.NumbersFitMode.Overflow;

//ワークブックを初期化します
var workbook = new GrapeCity.Documents.Excel.Workbook();

IWorksheet worksheet = workbook.Worksheets[0];

FileStream stream = File.Open(@"Logo.png", FileMode.Open, FileAccess.Read);

//背景画像を追加します
IBackgroundPicture picture = worksheet.BackgroundPictures.AddPictureInPixel(stream, ImageType.PNG, 10, 10, 500, 370);
//画像レイアウトを設定します
picture.BackgroundImageLayout = ImageLayout.Zoom;

//オプションを設定します
workbook.ActiveSheet.PageSetup.PrintGridlines = true;

//PDFファイルに保存します
workbook.Save("backgroundimage.pdf");

Workbook workbook = new Workbook();

string ssjson = string.Empty;
try
{
    var jsonFile = @"D:\bgimage.ssjson";

    using (StreamReader sr = System.IO.File.OpenText(jsonFile))
    {
        ssjson = sr.ReadToEnd();
    }
}
catch (Exception e)
{
    Console.WriteLine(e);
}

//ssjsonからインポートします
workbook.FromJson(ssjson);

//オプションを設定します
workbook.ActiveSheet.PageSetup.PrintGridlines = true;

//PDFにエクスポートします
workbook.Save("bgimage.pdf");

//ワークブックを初期化します
var workbook = new GrapeCity.Documents.Excel.Workbook();

//背景色を設定します
workbook.BookView.BackColor = Color.LightSkyBlue;
workbook.BookView.GrayAreaBackColor = Color.Gray;

//値をセルに設定します
IWorksheet worksheet = workbook.ActiveSheet;
worksheet.Range["H20"].Value = "The text";

//ページオプションを設定します
worksheet.PageSetup.PrintGridlines = true;
worksheet.PageSetup.PrintHeadings = true;

//PDFにエクスポートします
workbook.Save("backgroundcolor.pdf");

IWorkbook workbook = new Workbook();
IWorksheet worksheet = workbook.Worksheets[0];
worksheet.Range["A1"].Value = 1;
worksheet.Range["A11"].Value = 2;

//ワークシートの行数と列数を変更します
worksheet.RowCount = 10;
worksheet.ColumnCount = 10;

//JSONファイルに保存します
//SpreadJSでこのJSONファイルを開いて、行数が10行、列数が10列であることを確認します
FileStream file = new FileStream("RowColumnCount.json", FileMode.Create);
workbook.ToJson(file, new SerializationOptions { IgnoreRangeOutOfRowColumnCount = true });

// Initialize WorkbookOptions.
WorkbookOptions workbookOptions = new WorkbookOptions();

// Enable pixel-based column width for the workbook.
workbookOptions.PixelBasedColumnWidth = true;
var workbook = new Workbook(workbookOptions);

// Open SSJSON file.
workbook.Open("Event budget.ssjson");
IWorksheet worksheet = workbook.Worksheets[0];

// Save to a PDF and PNG file.
workbook.Save("SavePDFWithPixelBasedColumnWidth.pdf");
worksheet.ToImage("SavePDFWithPixelBasedColumnWidth.png");

//新しいワークブックを作成します
var workbook = new Workbook();
workbook.Worksheets.Add();

workbook.BookView.AllowSheetReorder = false;
workbook.BookView.TabEditable = false;
workbook.BookView.TabNavigationVisible = false;
workbook.BookView.TabStripPosition = SpreadJSTabStripPosition.Left;
workbook.BookView.TabStripWidth = 150;
workbook.BookView.NewTabVisible = false;
using var file = new FileStream("sheettabposition.json", FileMode.Create);
workbook.ToJson(file);

//新しいワークブックを作成します
var workbook = new Workbook();
IWorksheet worksheet = workbook.Worksheets[0];

CheckBoxListCellType cellType = new CheckBoxListCellType
{
    Direction = CellTypeDirection.Horizontal,
    TextAlign = CellTypeTextAlign.Right,
    IsFlowLayout = false,
    MaxColumnCount = 2,
    MaxRowCount = 1,
    HorizontalSpacing = 20,
    VerticalSpacing = 5,
    BoxSize = 40,
    AutoBoxSize = true
};
cellType.Items.Add(new SelectFieldItem("sample1", "1"));
cellType.Items.Add(new SelectFieldItem("sample2", "2"));
cellType.Items.Add(new SelectFieldItem("sample3", "3"));
cellType.Items.Add(new SelectFieldItem("sample4", "4"));
cellType.Items.Add(new SelectFieldItem("sample5", "5"));
worksheet.Range["A1:C3"].ColumnWidth = 25;
worksheet.Range["A1:C3"].CellType = cellType;
worksheet.Range["A1:C3"].Value = new object[,]
{
    {new object[]{"1", "3", "5" } }
};
using var file = new FileStream("checkboxlistsize.json", FileMode.Create);
workbook.ToJson(file);
}

static void Main(string[] args)
{
    Workbook workbook = new Workbook();
    workbook.Open("Picture.json");
    var pic = workbook.ActiveSheet.Shapes[0];
    //JSONファイルから画像のURLを取得します
    string url = pic.PictureFormat.Url;
    byte[] picByte = GetPictureFromUrl(url);
    //画像のバイト配列を設定します
    pic.PictureFormat.Fill = picByte;
    //PDFとExcelファイルに保存します
    workbook.Save("PicturePDF.pdf");
    workbook.Save("PictureExcel.xlsx");
}

private static byte[] GetPictureFromUrl(string url)
{
    WebClient wc = new WebClient();
    byte[] imageBytes = wc.DownloadData(url);
    return imageBytes;
}