Hello,
I'm trying to insert an new column in a loaded worksbook. When I insert it I resize an existing table so that the chart related to the table will update as well but it does not. Can you help me out ?
Thank you for contacting Infragistics!
The best way for us to assist you is if you provide a small isolated sample that we can run and use for debugging locally. If you are unable able to provide an isolated sample I may be able to give suggestions if you provide the code for your page.
Hi Mike,
So, I'm trying to insert an new column in a loaded workbook. When I insert it I resize an existing table so that the chart related to the table will update as well but it does not. And apparently there is no way to modify a loaded chart using infragistics. The only way I can access it is by Worksheet.Shapes collection but as you may guess it's just a shape where I cannot manipulate data in it.
So when I open the modified excel file, the table was well resized but on the other hand the chart that was related to the table is not updated. Its data source range is still the previous range of the table.
Here is what I did :
private static void Main() { string outputFile = "Book1.xlsm"; Workbook workbook = Workbook.Load(outputFile);
Workbook temp = SetIndicatorsWorkbook(); var jenkinsValues = new List(); for (int j = 0; j < 13; j++) { jenkinsValues.Add((int)temp.Worksheets["Unit & Integration Tests"].Rows[j].Cells[0].Value); }
var worksheet = workbook.Worksheets["Unit Testing"];
//id of column related to the first asset (fixedIncome) in the loaded worksheet var k = 8; var count = worksheet.Rows[8].Cells.Count(cell => cell.Value != null);
string lastCellAdress = WorksheetCell.GetCellAddressString(worksheet.Rows[20], worksheet.Columns[count + 1].Index, CellReferenceMode.A1, true); StringBuilder lastCellReference = new StringBuilder(); for (int i = 16; i < lastCellAdress.Length; i++) { if (!lastCellAdress[i].Equals('$')) { lastCellReference.Append(lastCellAdress[i]); }
} worksheet.Columns.Insert(count + 1); worksheet.Tables["Table5"].Resize(String.Format("C3:{0}", lastCellReference)); int totalValues = 0; foreach (var value in jenkinsValues) { worksheet.Rows[k].Cells[count + 1].Value = value; totalValues += value; k++; }
DateTime date = DateTime.Parse(worksheet.Rows[2].Cells[count].GetText()); worksheet.Rows[2].Cells[count + 1].Value = date.AddMonths(1); worksheet.Rows[4].Cells[count + 1].Value = totalValues;
workbook.Save(outputFile); }
After looking into this and doing some research, being able to modify/create a chart in an excel worksheet has been determined to be a new product idea. You can suggest new product ideas for future versions (or vote for existing ones) at <http://ideas.infragistics.com>.
There are many benefits to submitting a product idea:
- Direct communication with our product management team regarding your product idea.- Notifications whenever new information regarding your idea becomes available.- Ability to vote on your favorite product ideas to let us know which ones are the most important to you. You will have ten votes for this and can change which ideas you are voting for at any time.- Allow you to shape the future of our products by requesting new controls and products altogether.- You and other developers can discuss existing product ideas with members of our Product Management team.
Steps to create your idea: 1. Log into the Infragistics Product Idea site at http://ideas.infragistics.com (creating a new login if needed).2. Navigate to the product / platform channel of your choice (e.g. WPF, Windows Forms, ASP.NET, HTML5 / Ignite UI, iOS / NucliOS, etc.)3. Add your product idea and be sure to be specific and provide as much detail as possible. • Explain the context in which a feature would be used, why it is needed, why it can’t be accomplished today, and who would benefit from it. You can even add screenshots to build a stronger case. Remember that for your suggestion to be successful, you need other members of the community to vote for it. Be convincing!• Include a link to this thread in your idea so product management will be able to look back at this case.
The Product Idea site puts you in the driver’s seat and allows you to track the progress of your ideas at any time, see how many votes it got, read comments from other developers in the community, and see if someone from the product team has additional questions for you.
Thank you for contacting Infragistics.