cikaPero

Hi, there is a much more cleaner, faster and easier way to import Excel to DataSet. With GemBox.Spreadsheet Excel C# component this is all the code you need: var ef = new ExcelFile(); ef.LoadXls(@"c:\xlfile.xls"); // DataSet schema has to be defined before this. for(int i = 0; i < ef.Worksheets.Count; ++i) { var ws = ef.Worksheets[i]; ws.ExtractToDataTable(dataSet.Tables[i], ws.Rows.Count, ExtractDataOptions.StopAtFirstEmptyRow, ws.Rows[0], ws.Columns[0]); }

Hi, well if you are looking for easy, fast and clean solution, I recommend this Excel VB.NET component. Here is a code snippet of DataSet to Excel export: // Create new ExcelFile. var ef = new ExcelFile(); // Imports all the tables from DataSet to new file. foreach (DataTable dataTable in dataSet.Tables) { // Add new worksheet to the file. var ws = ef.Worksheets.Add(dataTable.TableName); // Insert the data from DataTable to the worksheet starting at cell "A1". ws.InsertDataTable(dataTable, "A1", true); } // Save the file to XLS format. ef.SaveXls("DataSet.xls");

Hi, I am using AdWords for advertising my products. But in a last couple of months number of products have doubled so I don't have enough time to optimize AdWords campaigns for all of them. Some campaigns have thousands of keywords so I am looking a way to automate my AdWords campaigns. I know about AdWords API and client libraries. I have been investigating them for some time and they are not so easy to use. I want to focus more on optimizing my AdWords campaigns, and not on communication with AdWords server. Does anyone know about some C#/VB.NET library that would allow me to download my AdWords data, investigate it, modify it and then upload modifications back on AdWords server? Thank you, Pero