All About Interview Of Devloper

Yes, ✅ you can do this directly in Excel using a formula — no code or external tool required . Here’s how you can achieve the same logic using a formula in Column N of the "Icon Tracker" sheet: 🧠 What You Want: For each row: Check if value in Column M exists in Column G of the "ICON management" sheet. If not found and the value is not "NA" , show: "Icon not present in management Sheet" . If value is "NA" → leave blank . ✅ Excel Formula for Column N (e.g., N2): =IF(OR(M2="NA", ISNUMBER(MATCH(M2, 'ICON management'!G:G, 0))), "", "Icon not present in management Sheet") 💡 Explanation: Part Meaning M2="NA" Checks if current row's value in Column M is "NA" (case-sensitive, use LOWER() for case-insensitive). MATCH(M2, 'ICON management'!G:G, 0) Looks for M2's value in Column G of "ICON management". Returns row number if fo...

Bdbjfjjfnnfnf

Great choice! ✅ ClosedXML is: 💯 Free for commercial and non-commercial use (MIT License). 🧼 Easier to use than EPPlus. 📁 Works with .xlsx files only. 🎯 Goal Recap We will use ClosedXML to: Open two Excel files. In File 1 , sheet "Icon Tracker" , read values from Column M . In File 2 , sheet "ICON management" , read values from Column G . For each value in Column M: If it’s not found in Column G → write "Icon not present in management Sheet" in Column N (same row). Save File 1 with the updates. 📦 Install ClosedXML In Package Manager Console : Install-Package ClosedXML 📄 ExcelService.cs Using ClosedXML using ClosedXML.Excel; using System; using System.Collections.Generic; using System.IO; namespace WpfIconCheckerApp.Models { public class ExcelService { public static string CompareExcelFiles(string file1Path, string file2Path) { try { using var workbook1 = new XLWorkbo...

Perfect! ✅ Let's replace Microsoft.Office.Interop.Excel with EPPlus , which: Doesn't require Microsoft Excel to be installed. Is much faster and more stable for server/desktop apps. 🔧 Updated Requirements Read 2 Excel files . In File 1 , "Icon Tracker" sheet → get Column M values. In File 2 , "ICON management" sheet → get Column G values. If value in Column M is not in Column G , write "Icon not present in management Sheet" in Column N . Use EPPlus (works on .xlsx only). 📦 Install EPPlus via NuGet Run this in the NuGet Package Manager: Install-Package EPPlus 🧠 Updated ExcelService.cs using EPPlus using OfficeOpenXml; using System.Collections.Generic; using System.IO; namespace WpfIconCheckerApp.Models { public class ExcelService { public static string CompareExcelFiles(string file1Path, string file2Path) { ExcelPackage.LicenseContext = LicenseContext.NonCommercial; try ...

Here’s a WPF application using MVVM pattern in C# that: Reads two Excel files . Compares values in Column M of the "Icon Tracker" sheet in the first Excel file with Column G of the "ICON management" sheet in the second Excel file. If a value from Column M is not present in Column G , it writes "Icon not present in management Sheet" in the corresponding Column N of the first Excel file. 🛠 Technologies Used C# WPF (MVVM) Microsoft.Office.Interop.Excel 📁 Folder Structure WpfIconCheckerApp/ ├── ViewModels/ │ └── MainViewModel.cs ├── Views/ │ └── MainWindow.xaml ├── Models/ │ └── ExcelService.cs ├── App.xaml ├── MainWindow.xaml.cs └── WpfIconCheckerApp.csproj 1️⃣ MainWindow.xaml (View) <Window x:Class="WpfIconCheckerApp.MainWindow" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:d="http://schemas.microsoft.com/expression/blend/2008" xmlns:x=...

The ADB command string to invoke Google Assistant is: adb shell am start -a com.google.android.googlequicksearchbox.action.ASSIST You can run this in C# by passing it as the argument string to adb .

To export the DataGrid content to an Excel (.xlsx) file , we’ll use ClosedXML — a popular .NET library for working with Excel files. ✅ Step-by-Step Update 📦 1. Install ClosedXML NuGet Package Run this in Package Manager Console : Install-Package ClosedXML 🧠 2. Update ViewModel ( MainViewModel.cs ) Add a new command: public ICommand ExportToExcelCommand => new RelayCommand(ExportToExcel); Add this method to MainViewModel : private void ExportToExcel() { var dialog = new SaveFileDialog { Filter = "Excel Workbook (*.xlsx)|*.xlsx" }; if (dialog.ShowDialog() == true) { using var workbook = new ClosedXML.Excel.XLWorkbook(); var worksheet = workbook.Worksheets.Add("Command Results"); worksheet.Cell(1, 1).Value = "Command ID"; worksheet.Cell(1, 2).Value = "ADB Command"; worksheet.Cell(1, 3).Value = "CAN Signal"; worksheet.Cell(1, 4).Value = "Expected Value";...

using System; using System.Runtime.InteropServices; using Excel = Microsoft.Office.Interop.Excel; namespace ExcelRedToBlack {     class Program     {         static void Main(string[] args)         {             Console.WriteLine("Enter full path to the Excel file:");             string filePath = Console.ReadLine();             if (string.IsNullOrWhiteSpace(filePath))             {                 Console.WriteLine("Invalid file path.");                 return;             }             Excel.Application excelApp = null;             Excel.Workbook workbook = null;             try         ...

🔄 Figma REST API – Version History ✅ Endpoint GET https://api.figma.com/v1/files/{file_key}/versions This endpoint retrieves the list of named versions for a given file. --- 🔐 Authentication Required Use a Personal Access Token (PAT) as a Bearer token in the Authorization header. You can create a PAT from: https://www.figma.com/developers/api --- 📌 How to Get file_key You get it from the Figma file URL: https://www.figma.com/file/<file_key>/<filename> Example: URL: https://www.figma.com/file/abc123XYZ/Design-v1   → file_key = abc123XYZ --- 📥 Example Request (with curl) curl -H "Authorization: Bearer YOUR_ACCESS_TOKEN" \      https://api.figma.com/v1/files/abc123XYZ/versions --- ✅ Example Response {   "versions": [     {       "id": "4452:4",       "created_at": "2025-07-25T10:00:00Z",       "label": "Wireframe Start",       "description": "Basic layout",     ...

To export layers as images from Figma using the REST API , you use the GET Image endpoint . ✅ Step-by-Step: Export Layers as Images 🔑 Prerequisites: Figma File Key – from the file URL: https://www.figma.com/file/**FILE_KEY**/... Node IDs – the layer(s) you want to export Personal Access Token – from Figma account settings 🧪 1. Get Node IDs (Layer IDs) Endpoint: GET https://api.figma.com/v1/files/{file_key} Returns a full file structure ( document ) Traverse the JSON to find id of the nodes/layers you want to export (e.g., text, image, button, frame) Example node ID: "25:12" 🖼️ 2. Export Node as Image Endpoint: GET https://api.figma.com/v1/images/{file_key} Query Parameters: ids : Comma-separated node IDs format : png , jpg , or svg scale : optional, defaults to 1 (can be 2 for high-res) use_absolute_bounds : optional for exporting only visible area Example Request: GET https://api.figma.com/v1/images/AbCDeFGHIjkL?ids=25:12&format=pn...

 Here's the PowerPoint slide data using only the first and second responses (which covered Figma REST API accessible data and a categorized API list): --- 🎯 Slide 1: Title Slide Title: Accessing Figma Data via REST API Subtitle: What’s Possible and What’s Not with Figma’s API --- ✅ Slide 2: What You Can Access via Figma REST API File & Design Data (Read-only): File metadata (name, modified date, version) Document structure (pages, frames, groups, nodes) Colors, fonts, layout, vectors, strokes, effects Local & team components Export images (PNG, JPG, SVG, PDF) Comments (read, post, resolve) Version history Project and team data (for Org accounts) --- ❌ Slide 3: What You Cannot Access via API Limitations: No write/edit of nodes or layout Cannot simulate or control prototypes No real-time collaboration info (like cursors) No plugin execution Cannot access plugin-specific or private data No access to interactions/animations execution --- 🌐 Slide 4: Key API Endpoints Purpose E...