static void Main(string[] args)
{
WindowEnumerator enumerator = new WindowEnumerator("XLMAIN");
DateTime startTime = DateTime.Now;
IntPtr[] handles = enumerator.EnumerateWindows(1000);
if (null != handles)
{
foreach (IntPtr item in handles)
{
object proxy = ExcelApplicationWindow.GetApplicationProxyFromHandle(item);
if (null != proxy)
{
NetOffice.ExcelApi.Application application = new NetOffice.ExcelApi.Application(null, proxy);
Console.WriteLine("Excel.Application Hwnd:{0}", application.Hwnd);
}
}
}
else
{
Console.WriteLine("Enumerate Windows failed because the timeout is reached.");
}
Console.WriteLine("Press any key..");
Console.ReadKey();
}
static void Main(string[] args)
{
using (var wordApp = new NetOffice.WordApi.Application())
using (var excelApp = new NetOffice.ExcelApi.Application())
{
var doc = wordApp.Documents.Open("C:\\Users\\John\\Desktop\\test.docx");
var xls = excelApp.Workbooks.Open("C:\\Users\\John\\Desktop\\test.xlsx");
var customProperties = (DocumentProperties)doc.CustomDocumentProperties;
foreach (var property in customProperties)
{
Console.WriteLine(String.Format("Name: {0}, Value: {1}, Type: {2}", property.Name, property.Value, property.Type));
}
customProperties = (DocumentProperties)xls.CustomDocumentProperties;
foreach (var property in customProperties)
{
Console.WriteLine(String.Format("Name: {0}, Value: {1}, Type: {2}", property.Name, property.Value, property.Type));
}
}
Console.ReadKey();
}
/*
* public override string GetCustomUI(string ribbonId)
* {
* _excel = new Application(null, ExcelDna.Integration.ExcelDnaUtil.Application);
* string ribbonXml = GetCustomRibbonXML();
* return ribbonXml;
* }
*
* private string GetCustomRibbonXML()
* {
* string ribbonXml;
* var thisAssembly = typeof(CustomRibbon).Assembly;
* var resourceName = typeof(CustomRibbon).Namespace + ".CustomRibbon.xml";
*
* using (Stream stream = thisAssembly.GetManifestResourceStream(resourceName))
* using (StreamReader reader = new StreamReader(stream))
* {
* ribbonXml = reader.ReadToEnd();
* }
*
* if (ribbonXml == null)
* {
* throw new MissingManifestResourceException(resourceName);
* }
* return ribbonXml;
* }
*/
public void OnLoad(IRibbonUI ribbon)
{
if (ribbon == null)
{
throw new ArgumentNullException(nameof(ribbon));
}
_thisRibbon = ribbon;
_excel = new Application(null, ExcelDna.Integration.ExcelDnaUtil.Application); //added this
//_excel.WorkbookActivateEvent += OnInvalidateRibbon;
//_excel.WorkbookDeactivateEvent += OnInvalidateRibbon;
//_excel.SheetActivateEvent += OnInvalidateRibbon;
//_excel.SheetDeactivateEvent += OnInvalidateRibbon;
_thisRibbon.Invalidate();
//if (_excel.ActiveWorkbook == null)
//{
// _excel.Workbooks.Add();
//}
//get apikey
Utils.apiKey = System.Configuration.ConfigurationManager.AppSettings["apiKey"];
//get projects;
_projects = Projects.GetProjects(Utils.apiKey);
}
static void Main(string[] args)
{
WindowEnumerator enumerator = new WindowEnumerator("XLMAIN");
DateTime startTime = DateTime.Now;
IntPtr[] handles = enumerator.EnumerateWindows(1000);
if (null != handles)
{
foreach (IntPtr item in handles)
{
object proxy = ExcelApplicationWindow.GetApplicationProxyFromHandle(item);
if (null != proxy)
{
NetOffice.ExcelApi.Application application = new NetOffice.ExcelApi.Application(null, proxy);
Console.WriteLine("Excel.Application Hwnd:{0}", application.Hwnd);
}
}
}
else
{
Console.WriteLine("Enumerate Windows failed because the timeout is reached.");
}
Console.WriteLine("Press any key..");
Console.ReadKey();
}
public override string GetCustomUI(string ribbonId)
{
_excel = new Application(null, ExcelDna.Integration.ExcelDnaUtil.Application);
string ribbonXml = GetCustomRibbonXML();
return(ribbonXml);
}
static void Main(string[] args)
{
var excel = new NetOffice.ExcelApi.Application();
var word = new NetOffice.WordApi.Application();
var outlook = new NetOffice.OutlookApi.Application();
var powerpoint = new NetOffice.PowerPointApi.Application();
}
public String Version()
{
using (var excel = new NetOffice.ExcelApi.Application())
{
var version = excel.Version;
excel.Quit();
return version;
}
}
public MainWindow()
{
InitializeComponent();
using (var excelApplication = new NetOffice.ExcelApi.Application())
{
try
{
// Création du fichier de travail.
var workBook = excelApplication.Workbooks.Add();
// Positionnement sur le premier onglet.
var workSheet = (NetOffice.ExcelApi.Worksheet)workBook.Worksheets[1];
// Ajout des données dans les différentes cellules.
workSheet.Cells[1, 2].Value = "Langues (en millions de locuteurs) :";
workSheet.Cells[2, 1].Value = "Mandarin";
workSheet.Cells[2, 2].Value = "860";
workSheet.Cells[3, 1].Value = "Espagnol";
workSheet.Cells[3, 2].Value = "469";
workSheet.Cells[4, 1].Value = "Anglais";
workSheet.Cells[4, 2].Value = "362";
workSheet.Cells[5, 1].Value = "Arabe";
workSheet.Cells[5, 2].Value = "276";
workSheet.Cells[6, 1].Value = "Bengali";
workSheet.Cells[6, 2].Value = "270";
workSheet.Cells[7, 1].Value = "Hindi";
workSheet.Cells[7, 2].Value = "269";
workSheet.Cells[8, 1].Value = "Portugais";
workSheet.Cells[8, 2].Value = "222";
workSheet.Cells[9, 1].Value = "Russe";
workSheet.Cells[9, 2].Value = "150";
workSheet.Cells[10, 1].Value = "Japonais";
workSheet.Cells[10, 2].Value = "125";
workSheet.Cells[11, 1].Value = "Lahnda/Pendjabi";
workSheet.Cells[11, 2].Value = "112";
// Ajout d'un diagramme et positionnement.
var chart = ((NetOffice.ExcelApi.ChartObjects)workSheet.ChartObjects()).Add(150, 200, 500, 400);
// Définition du type de diagramme.
chart.Chart.ChartType = NetOffice.ExcelApi.Enums.XlChartType.xlPie;
// Association du diagramme aux données de la grille.
chart.Chart.SetSourceData(workSheet.Range("A1:B11"));
// Enregistrement du fichier.
workBook.SaveAs(@"C:\Users\toky\Desktop\newDep\test.xlsx");
}
finally
{
// Sortie de l'application Excel.
excelApplication.Quit();
}
}
}
private static void Verify0000001002560(string filename)
{
using (var excel = new NetOffice.ExcelApi.Application())
{
var workBook = excel.Workbooks.Open(filename);
var workSheet = (NetOffice.ExcelApi.Worksheet)workBook.Worksheets[1];
Assert.AreEqual("reading.test", workSheet.Cells[2, 1].Value);
Assert.AreEqual("読み込みテスト", workSheet.Cells[2, 2].Value);
excel.Quit();
}
}
/// <summary>
/// Destruct the Office application objects and remove event handlers
/// </summary>
private void DestructApplication()
{
if (this.excelApplication != null)
{
// unregister events
this.excelApplication.WorkbookActivateEvent -= this.OnWorkbookActivateEvent;
this.excelApplication.WorkbookDeactivateEvent -= this.OnWorkbookDeactivateEvent;
// set excel instance to null
this.officeApplicationWrapper.Excel = null;
this.excelApplication = null;
}
}
public void CreateReport(string outFilePath)
{
using (var excelApp = new NetOffice.ExcelApi.Application())
{
excelApp.DisplayAlerts = false;
var workbook = excelApp.Workbooks.Add();
CreateCompetitorListWorksheet(workbook.Worksheets[1] as NetOffice.ExcelApi.Worksheet);
CreateSpectatorListWorksheet(workbook.Worksheets.Add(Type.Missing, workbook.Worksheets[workbook.Worksheets.Count]) as NetOffice.ExcelApi.Worksheet);
CreateRefereeListWorksheet(workbook.Worksheets.Add(Type.Missing, workbook.Worksheets[workbook.Worksheets.Count]) as NetOffice.ExcelApi.Worksheet);
CreateCoachListWorksheet(workbook.Worksheets.Add(Type.Missing, workbook.Worksheets[workbook.Worksheets.Count]) as NetOffice.ExcelApi.Worksheet);
CreateSparringListWorksheet(workbook.Worksheets.Add(Type.Missing, workbook.Worksheets[workbook.Worksheets.Count]) as NetOffice.ExcelApi.Worksheet);
CreateFormsListWorksheet(workbook.Worksheets.Add(Type.Missing, workbook.Worksheets[workbook.Worksheets.Count]) as NetOffice.ExcelApi.Worksheet);
workbook.SaveAs(outFilePath);
excelApp.Quit();
}
}
public bool IsRegistered()
{
var app = new NetOffice.ExcelApi.Application();
// grab an immutable copy of the installed Excel version code
var versionToken = app.Version;
var key = Registry.CurrentUser.OpenSubKey($"Software\\Microsoft\\Office\\{versionToken}\\Excel\\Options", true);
if (key == null)
{
return(false);
}
var allChildValues = key.GetValueNames();
// check if the plug-in is already installed...
var openValues = allChildValues.Where(v => v.StartsWith("OPEN")).ToList();
var result = openValues.Any(v => key.GetValue(v).ToString().Contains(registerName));
key.Close();
return(result);
}
/// <summary>
/// Initialize the Office application objects, setup event handlers
/// </summary>
/// <param name="application">
/// The application object that is used in the current addin
/// </param>
private void InitializeApplication(object application)
{
var excel = application as NetOffice.ExcelApi.Application;
if (excel != null)
{
// set the excel application object
this.excelApplication = excel;
this.excelApplication.DisplayAlerts = true;
this.excelApplication.ScreenUpdating = true;
// set the excel instance to the office application wrapper
this.officeApplicationWrapper.Excel = excel;
// create event handlers
this.excelApplication.WorkbookActivateEvent += this.OnWorkbookActivateEvent;
this.excelApplication.WorkbookDeactivateEvent += this.OnWorkbookDeactivateEvent;
logger.Debug("The current addin is loaded for Excel");
return;
}
}
public void Register()
{
var app = new NetOffice.ExcelApi.Application();
var version = app.Version;
app.Quit();
var key = Registry.CurrentUser.OpenSubKey($"Software\\Microsoft\\Office\\{version}\\Excel\\Options", true);
if (key == null)
{
return;
}
var allChildValues = key.GetValueNames();
// check if the plug-in is already installed...
var openValues = allChildValues.Where(v => v.StartsWith("OPEN")).ToList();
if (openValues.Any(v => key.GetValue(v).ToString().Contains(registerName)))
{
return;
}
var path = InstallationPath;
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
var xllToRegister = $"{path}\\{registerName}";
var incr = openValues.Count > 1 ? (openValues.Count - 1).ToString() : "";
var newOpenValue = $"OPEN{incr}";
key.SetValue(newOpenValue, xllToRegister);
key.Close();
}
private static bool?IsExcelPasswordProtected(string fileName)
{
using (var exceldApplication = new NetOffice.ExcelApi.Application())
{
try
{
// exceldApplication.Visible = false;
//exceldApplication.show
//var newWorkbook = exeldApplication.Workbooks.Open(fileName, false, true, string.Empty, "test" );
var newWorkbook = exceldApplication.Workbooks.Open(fileName, null, null, null, password: "******");
// read text of document
string text = newWorkbook.Sheets[0].ToString();
}
catch (Exception e)
{
var inner = e.InnerException;
if (inner?.InnerException != null)
{
inner = inner.InnerException;
string sErrorMessage = inner.Message;
if (sErrorMessage.StartsWith("The password is incorrect") || sErrorMessage.StartsWith("Het wachtwoord is onjuist"))
{
return(true);
}
}
else
{
return(null);
}
}
return(false);
}
}
void makeGraph()
{
// Open Excel API
using (var excelApplication = new NetOffice.ExcelApi.Application())
{
// Add workbook
var workBook = excelApplication.Workbooks.Add();
workBook.Worksheets.Add();
// set worksheet to set data
var dataSheet = (NetOffice.ExcelApi.Worksheet)workBook.Worksheets[1];
dataSheet.Name = "Data";
// set worksheet to set chart
var chartSheet = (NetOffice.ExcelApi.Worksheet)workBook.Worksheets[2];
chartSheet.Name = "Charts";
// input data
progressBar1.Maximum = li.Count;
for (int i = 0; i < li.Count; i++)
{
dataSheet.Cells[1, i + 1].Value = fileName[i];
for (int j = 0; j < li[i].Count; j++)
{
dataSheet.Cells[j + 2, i + 1].Value = li[i][j];
}
var chart = ((NetOffice.ExcelApi.ChartObjects)chartSheet.ChartObjects()).Add(0, 200*i, 350, 200);
chart.Chart.ChartType = NetOffice.ExcelApi.Enums.XlChartType.xlLine;
chart.Chart.SetSourceData(dataSheet.Range(dataSheet.Cells[1, i + 1], dataSheet.Cells[li[i].Count, i + 1]));
progressBar1.PerformStep();
}
workBook.SaveAs(sfd());
excelApplication.Quit();
}
}
void NetOffice.ExcelApi.Tools.ITaskPane.OnConnection(NetOffice.ExcelApi.Application application, object[] customArguments)
{
}
public SettingsForm(Application xl)
{
_excel = xl;
InitializeComponent();
}
public void OnConnection(NetOffice.ExcelApi.Application application, NetOffice.OfficeApi._CustomTaskPane parentPane, object[] customArguments)
{
Counter = new PerformanceCounter("Process", "% Processor Time", "Excel");
UsageTimer.Enabled = true;
}
public void OnConnection(NetOffice.ExcelApi.Application application, NetOffice.OfficeApi._CustomTaskPane parentPane, object[] customArguments)
{
StartTime = DateTime.Now;
buttonEnabled_Click(buttonEnabled, new EventArgs());
}
private async Task <StreamlabsChatBotData> GatherStreamlabsChatBotSettings(string filePath)
{
try
{
StreamlabsChatBotData data = new StreamlabsChatBotData();
await Task.Run(() =>
{
using (NetOffice.ExcelApi.Application application = new NetOffice.ExcelApi.Application())
{
application.DisplayAlerts = false;
NetOffice.ExcelApi.Workbook workbook = application.Workbooks.Open(filePath);
if (workbook != null)
{
foreach (NetOffice.ExcelApi.Worksheet worksheet in workbook.Worksheets.AsEnumerable())
{
if (worksheet != null)
{
List <List <string> > dataValues = new List <List <string> >();
int totalColumns = 0;
bool hasValue = false;
do
{
hasValue = false;
NetOffice.ExcelApi.Range range = worksheet.Cells[1, totalColumns + 1];
if (range.Value != null)
{
totalColumns++;
hasValue = true;
}
} while (hasValue);
int currentRow = 2;
List <string> values = new List <string>();
do
{
values = new List <string>();
for (int i = 1; i <= totalColumns; i++)
{
NetOffice.ExcelApi.Range range = worksheet.Cells[currentRow, i];
if (range.Value != null)
{
values.Add(range.Value.ToString());
}
else
{
values.Add(string.Empty);
}
}
if (!values.All(v => string.IsNullOrEmpty(v)))
{
dataValues.Add(values);
}
currentRow++;
} while (!values.All(v => string.IsNullOrEmpty(v)));
if (worksheet.Name.Equals("Commands"))
{
data.AddCommands(dataValues);
}
else if (worksheet.Name.Equals("Timers"))
{
data.AddTimers(dataValues);
}
else if (worksheet.Name.Equals("Quotes") || worksheet.Name.Equals("Extra Quotes"))
{
data.AddQuotes(dataValues);
}
else if (worksheet.Name.Equals("Ranks"))
{
data.AddRanks(dataValues);
}
else if (worksheet.Name.Equals("Currency"))
{
data.AddViewers(dataValues);
}
else if (worksheet.Name.Equals("Events"))
{
data.AddEvents(dataValues);
}
}
}
}
application.Quit();
}
});
return(data);
}
catch (Exception ex)
{
Logger.Log(ex);
}
return(null);
}
void NetOffice.ExcelApi.Tools.ITaskPane.OnConnection(NetOffice.ExcelApi.Application application, NetOffice.OfficeApi._CustomTaskPane parentPane, object[] customArguments)
{
TestAddin addin = customArguments[0] as TestAddin;
addin.TaskPaneOkay = true;
}
public void OnConnection(NetOffice.ExcelApi.Application application, NetOffice.OfficeApi._CustomTaskPane parentPane, object[] customArguments)
{
}
