Inserisci intervalli

introduzione

In Excel, puoi selezionare un intervallo, quindi inserire un intervallo e spostare altri dati a destra o in basso.

Aspose.Cells fornisceCells.InsertRange per inserire un intervallo.

Inserisci una gamma e sposta le celle a destra come i seguenti codici con Aspose.Cells:

+		   // Instantiate a new Workbook.
+        Workbook workbook = new Workbook();
+        // Get all the worksheets in the book.
+        WorksheetCollection worksheets = workbook.getWorksheets();
+        // Get the first worksheet in the worksheets collection.
+        Worksheet worksheet = workbook.getWorksheets().get(0);
+        // Create a range of cells.
+        Range sourceRange = worksheet.getCells().createRange("A1", "A2");
+        // Set a few cells in the range.
+        sourceRange.get(0, 0).putValue("Test");
+        sourceRange.get(1, 0).putValue("123");
+        CellArea ca = CellArea.createCellArea("A1", "A2");
+        worksheet.getCells().insertRange(ca, ShiftType.RIGHT);
+        String b1Value = worksheet.getCells().get("B1").getStringValue();// "Test"

Inserisci un range e sposta le celle verso il basso come i seguenti codici con Aspose.Cells:

+		   // Instantiate a new Workbook.
+        Workbook workbook = new Workbook();
+        // Get all the worksheets in the book.
+        WorksheetCollection worksheets = workbook.getWorksheets();
+        // Get the first worksheet in the worksheets collection.
+        Worksheet worksheet = workbook.getWorksheets().get(0);
+        // Create a range of cells.
+        Range sourceRange = worksheet.getCells().createRange("A1", "A2");
+        // Set a few cells in the range.
+        sourceRange.get(0, 0).putValue("Test");
+        sourceRange.get(1, 0).putValue("123");
+        CellArea ca = CellArea.createCellArea("A1", "A2");
+        worksheet.getCells().insertRange(ca, ShiftType.DOWN);
+        String a3Value = worksheet.getCells().get("A3").getStringValue();// "Test"