C# – Anh Tèng nè

Throttling Concurrent Outgoing HTTP Requests in .NET Core

May 5, 2020 Tèng Comments 0 Comment

In my last post, we implemented the rate limiting for an API endpoint on the server side. The server side rate limiting is useful for API providers to ensure system performance and/or to realize business values. On the client side, the API consumers then should throttle the rate of concurrent HTTP requests in order to comply with the rate limits of the endpoints and moderate the usage of client side resources. This post will go over how to make concurrent outgoing HTTP requests on the client…

HttpClient with proxy

August 12, 2019 Tèng Comments 0 Comment

Loop Through An Objects Properties In C#

December 7, 2018 Tèng Comments 0 Comment

By Jon Skeet: More compact and modern syntax:

Detect pivot table in Microsoft Excel using Interop c#

July 21, 2018 Tèng Comments 0 Comment

Here is some code for reference. Identify the overall Range occupied by PivotTables in the sheet and validate whether the cell is a part of the Range.

private Excel.Range IdentifyPivotRanges(Excel.Range xlRange)
{
    Excel.Range pivotRanges = null;
    Excel.PivotTables pivotTables = xlRange.Worksheet.PivotTables();
    int pivotCount = pivotTables.Count;
    for (int i = 1; i <= pivotCount; i++)
    {
        Excel.Range tmpRange = xlRange.Worksheet.PivotTables(i).TableRange2;
        if (pivotRanges == null) pivotRanges = tmpRange;
        pivotRanges = this.Application.Union(pivotRanges, tmpRange);
    }
    return pivotRanges;
}

private void CheckCellsForPivot(Excel.Range xlRange)
{
    Excel.Range pivotRange = IdentifyPivotRanges(xlRange);
    int rowCount = xlRange.Rows.Count;
    int colCount = xlRange.Columns.Count;
    for (int iRow = 1; iRow <= rowCount; iRow++)
    {
        for (int iCol = 1; iCol <= colCount; iCol++)
        {
            var cell = xlRange.Cells[iRow, iCol];
            if (Application.Intersect(pivotRange, cell) != null)
            {
                int rowLocation = iRow;
                int colLocation = iCol;
            }
        }
    }
}

private Excel.Range IdentifyPivotRanges(Excel.Range xlRange)

{

Excel.Range pivotRanges = null;

Excel.PivotTables pivotTables = xlRange.Worksheet.PivotTables();

int pivotCount = pivotTables.Count;

for (int i = 1; i <= pivotCount; i++)

{

Excel.Range tmpRange = xlRange.Worksheet.PivotTables(i).TableRange2;

if (pivotRanges == null) pivotRanges = tmpRange;

pivotRanges = this.Application.Union(pivotRanges, tmpRange);

}

return pivotRanges;

}

private void CheckCellsForPivot(Excel.Range xlRange)

{

Excel.Range pivotRange = IdentifyPivotRanges(xlRange);

int rowCount = xlRange.Rows.Count;

int colCount = xlRange.Columns.Count;

for (int iRow = 1; iRow <= rowCount; iRow++)

{

for (int iCol = 1; iCol <= colCount; iCol++)

{

var cell = xlRange.Cells[iRow, iCol];

if (Application.Intersect(pivotRange, cell) != null)

{

int rowLocation = iRow;

int colLocation = iCol;

}

For refresh pivot table:

pivotSheet.Activate();
Microsoft.Office.Interop.Excel.PivotTables pivotTables = 
        (Microsoft.Office.Interop.Excel.PivotTables)pivotSheet.PivotTables(missing);
int pivotTablesCount = pivotTables.Count;  
    if (pivotTablesCount > 0)
    {
        for (int i = 1; i <= pivotTablesCount; i++)
        {
            pivotTables.Item(i).RefreshTable(); //The Item method throws an exception
        }
    }

pivotSheet.Activate();

Microsoft.Office.Interop.Excel.PivotTables pivotTables =

(Microsoft.Office.Interop.Excel.PivotTables)pivotSheet.PivotTables(missing);

int pivotTablesCount = pivotTables.Count;

if (pivotTablesCount > 0)

{

for (int i = 1; i <= pivotTablesCount; i++)

{

pivotTables.Item(i).RefreshTable(); //The Item method throws an exception

}

Property Design

June 29, 2018 Tèng Comments 0 Comment

Although properties are technically very similar to methods, they are quite different in terms of their usage scenarios. They should be seen as smart fields. They have the calling syntax of fields, and the flexibility of methods. ✓ DO create get-only properties if the caller should not be able to change the value of the property. Keep in mind that if the type of the property is a mutable reference type, the property value can be changed even if the property…

Anh Tèng nè

Trà đá chém gió cùng a Tèng

Browsed by
Category: C#