public static void AddPictures(GcSpreadSheet spread)
{
OpenFileDialog fileDialog = new OpenFileDialog();
fileDialog.DefaultExt = "All Pictures (*.bmp;*.png;*.gif;*.jpg;*.jpeg)|*.bmp;*.png;*.gif;*.jpg;*.jpeg";
fileDialog.Filter = "All files (*.*)|*.*|All Pictures (*.bmp;*.png;*.gif;*.jpg;*.jpeg)|*.bmp;*.png;*.gif;*.jpg;*.jpeg|Windows Bitmap (*.bmp)|*.bmp|Portable Network Graphics (*.png)|*.png|Graphics Interchange Format (*.gif)|*.gif|JPEG File Interchange Format (*.jpg;*.jpeg)|*.jpg;*jpeg";
fileDialog.FilterIndex = 2;
fileDialog.Multiselect = true;
bool? result = fileDialog.ShowDialog();
if (result != null && result.Value && fileDialog.FileNames.Length > 0)
{
string[] fileNames = fileDialog.FileNames;
string[] safeFileNames = fileDialog.SafeFileNames;
AddPictures(fileNames, safeFileNames, spread.ActiveSheet);
}
spread.View.InvalidateCharts();
}
private static void SpreadSaveFile(GcSpreadSheet spread, Stream stream, string extension)
{
switch (extension)
{
case "SSXML":
spread.SaveXml(stream);
break;
case "XLS":
spread.SaveExcel(stream, ExcelFileFormat.XLS, ExcelSaveFlags.NoFlagsSet);
break;
case "XLSX":
spread.SaveExcel(stream, ExcelFileFormat.XLSX, ExcelSaveFlags.NoFlagsSet);
break;
default:
break;
}
}
private static void SpreadOpenFile(GcSpreadSheet spread, Stream stream, string extension)
{
using (Stream fileStream = stream)
{
switch (extension)
{
case "SSXML":
spread.OpenXml(fileStream);
break;
case "XLS":
case "XLSX":
spread.OpenExcel(fileStream, ExcelOpenFlags.NoFlagsSet);
break;
default:
break;
}
}
}
public static void SaveFile(GcSpreadSheet spread)
{
SaveFileDialog sfdia = new SaveFileDialog();
//sfdia.FileName = "Document"; // Default file name
sfdia.DefaultExt = ".xlsx"; // Default file extension
sfdia.Filter = "excel file(*.xlsx;*.xls)|*.xlsx;*.xls|spread file(*.ssxml)|*.ssxml|all files(*.*)|*.*";
bool? isOK = sfdia.ShowDialog();
if (isOK != null && isOK.Value)
{
#if WPF
using (FileStream fs = new FileStream(sfdia.FileName, FileMode.OpenOrCreate, FileAccess.Write))
{
SpreadSaveFile(spread, fs, TestHelper.GetUpperExtension(sfdia.FileName));
}
#elif SL
using (var stream = sfdia.OpenFile())
{
SpreadSaveFile(spread, stream, TestHelper.GetUpperExtension(sfdia.SafeFileName));
}
#endif
}
}
public static void OpenFile(GcSpreadSheet spread)
{
OpenFileDialog ofdia = new OpenFileDialog();
#if WPF
ofdia.RestoreDirectory = true;
#endif
ofdia.Filter = "excel file(*.xlsx;*.xls)|*.xlsx;*.xls|spread file(*.ssxml)|*.ssxml|all files(*.*)|*.*";
bool? isOK = ofdia.ShowDialog();
if (isOK != null && isOK.Value)
{
#if WPF
SpreadOpenFile(spread, ofdia.OpenFile(), TestHelper.GetUpperExtension(ofdia.FileName));
#elif SL
SpreadOpenFile(spread, ofdia.File.OpenRead(), TestHelper.GetUpperExtension(ofdia.File.Name));
#endif
}
}
